# Column not displaying data correctly in report designer

**URL:** <https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155>\
**Category:** Ignition\
**Tags:** ignition81, database, vision\
**Created:** [August 18, 2022, 1:42pm UTC](https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155 "2022-08-18T13:42:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\
**Post date:** [August 18, 2022, 1:42pm UTC](https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155/1 "2022-08-18T13:42:59Z")

</div>

Hello!

I am building out a report in the report designer and noticed my value for the `SalesDate` column is not showing up in the table I have built out. Also, my `Scrap_Percentage_Sales` column has a value in the DB but looks to be formatting in a weird way.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/c/4cf6b11576349baa2a930ede402d21c5128f174d.png)

I did try changing the number format for the `% Sales` cell as well as the date format for the `SalesDate` column. There is also data within the XML which makes me believe the data is there, just not displaying properly.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/5/95e4efed941b160c4f6add1de841174598ab8b55.png)

Let me know if I missed anything, thank you!

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [August 18, 2022, 2:08pm UTC](https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155/2 "2022-08-18T14:08:54Z")

</div>

That looks like an infinity symbol. Is there math going on in the gathering of data?

---

<div class="post-metadata">

**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\
**Post date:** [August 18, 2022, 2:16pm UTC](https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155/4 "2022-08-18T14:16:44Z")

</div>

Actually, I am doing math within the Object summary. I am diving the `Scrap Cost` by the `Sales` column. I bet that is the cause of the issue.

If I wanted to set a negative value to 0, should I do that within my query? Or is there functionality within the report designer to do this?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [August 18, 2022, 4:13pm UTC](https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155/5 "2022-08-18T16:13:02Z")

</div>

I’m willing to bet that the null value for Scrap Cost is going to affect the calculation. It would be more efficient to take care of values and calculations like that in the query

---

<div class="post-metadata">

**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\
**Post date:** [August 18, 2022, 4:27pm UTC](https://forum.inductiveautomation.com/t/column-not-displaying-data-correctly-in-report-designer/63155/6 "2022-08-18T16:27:48Z")

</div>

Makes sense, I will do that! Thank you for the help!