# \[IGN-7725\] Perspective table has trouble displaying tiny double/float values **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [May 11, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/ign-7725-perspective-table-has-trouble-displaying-tiny-double-float-values/73602 "2023-05-11T16:10:23Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![justin.brzozoski](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justin.brzozoski/32/13452_2.png) [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Post date:** [May 11, 2023, 4:10pm UTC](https://forum.inductiveautomation.com/t/ign-7725-perspective-table-has-trouble-displaying-tiny-double-float-values/73602/1 "2023-05-11T16:10:23Z")
Bumped into this one on production... 😞 We had a table with a column that was so close to zero as to be irrelevant, and the Perspective table just shows `NaN`... Paste this into a table's data property and you get it right away: ```auto [{ "TinyValue": 7.496146992025388e-8 }] ``` If I change the `numberFormat` setting for the TinyValue column to "none" or "scientific" it will start working but display excessive detail. I really just want it to show a "0" or "0.00". This also happens using a dataset for the data property, so I suspect it is not source datatype dependent. Why can't the standard "number" formatter handle this and just show a value near 0? ---
**Author:** ![justin.brzozoski](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justin.brzozoski/32/13452_2.png) [@justin.brzozoski](https://forum.inductiveautomation.com/u/justin.brzozoski)\ **Post date:** [May 16, 2023, 6:07pm UTC](https://forum.inductiveautomation.com/t/ign-7725-perspective-table-has-trouble-displaying-tiny-double-float-values/73602/2 "2023-05-16T18:07:02Z")
Ran this through a support ticket after not getting a response here, and they confirmed it is an issue and opened a ticket which i just put in the subject line.