# 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:** 2

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [June 2, 2023, 4:53pm UTC](https://forum.inductiveautomation.com/t/table-cell-displays-nan-for-small-number-bug/74503/2 "2023-06-02T16:53:23Z")

</div>

Check that you're not passing scientific notation as a string.

> [@Percent Values show as NaN% if they're very small in number format table column](https://forum.inductiveautomation.com/t/percent-values-show-as-nan-if-theyre-very-small-in-number-format-table-column/25554/2):
>
> I fixed it. It’s because my Python script was passing very-small values as STRINGS in scientific notation (i.e: "1.53421e-9") instead of as an actual number. This caused Ignition to throw up a NaN when it was given a string instead of a numeric value. Adding code to account for this and force very small numbers to 0 fixed the problem.

---

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