# Table cell displays NaN for small number (Bug ?)

**URL:** <https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 2, 2023, 4:47pm UTC](https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503 "2023-06-02T16:47:34Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**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:** [June 2, 2023, 8:11pm UTC](https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503/8 "2023-06-02T20:11:38Z")

</div>

A bug is part of your issue:

> [@\[IGN-7725\] Perspective table has trouble displaying tiny double/float values](https://forum.inductiveautomation.com/t/ign-7725-perspective-table-has-trouble-displaying-tiny-double-float-values/73602):
>
> Bumped into this one on production... disappointed 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: [{ "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 …

---

_[View the full topic](https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503)._