# Boolean showing decimals

**URL:** <https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [November 14, 2019, 2:10pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949 "2019-11-14T14:10:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![serenaz](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@serenaz](https://forum.inductiveautomation.com/u/serenaz)\
**Post date:** [November 14, 2019, 2:10pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949/1 "2019-11-14T14:10:35Z")

</div>

I am importing Boolean tags but when I drag them on the power table, two of them show as decimals instead of 0 and 1.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/139b0cbaaf6148fbf09cbcdfd5c13806f680c5a4.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0c7c247fcef99988a33d86379f76e47796d50b6f.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8c7b0b1a634a5df935041b6a57dec5b40b14a512.png)

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [November 14, 2019, 2:51pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949/2 "2019-11-14T14:51:30Z")

</div>

What’s the number format set to on those columns in the table customizer?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3c592983cda0dd5b600403e78c8c5de270ad0f2c.png)  
Consider setting the “Boolean?” flag on all the columns in the table customizer.

---

<div class="post-metadata">

**Author:** ![serenaz](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@serenaz](https://forum.inductiveautomation.com/u/serenaz)\
**Post date:** [November 14, 2019, 3:48pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949/3 "2019-11-14T15:48:33Z")

</div>

The number format is the same as you have in the photo. By setting the “Boolean?” flag do you mean checking all the boxes in the table customizer?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7c009aecc3fac2053d833faccc402206479bbd69.png)  
Now, 4 out of the 6 Boolean tags are corrupted

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [November 14, 2019, 4:27pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949/4 "2019-11-14T16:27:41Z")

</div>

You could change the number format to “0” and should then see only 0 or 1 in the cells. Or you could check the boolean option to display these as checkboxes in the cells.

---

<div class="post-metadata">

**Author:** ![serenaz](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@serenaz](https://forum.inductiveautomation.com/u/serenaz)\
**Post date:** [November 14, 2019, 4:32pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949/5 "2019-11-14T16:32:07Z")

</div>

I changed the aggregation mode from time-weighted average to closet value and that solved the issue!

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [November 14, 2019, 4:34pm UTC](https://forum.inductiveautomation.com/t/boolean-showing-decimals/29949/6 "2019-11-14T16:34:11Z")

</div>

I was focusing on the display end, but that setting explains why you were getting decimal values in the first place and is a better solution. Glad you got it figure out!