# Percent Values show as NaN% if they're very small in number format table column

**URL:** <https://forum.inductiveautomation.com/t/percent-values-show-as-nan-if-theyre-very-small-in-number-format-table-column/25554>\
**Category:** Ignition\
**Created:** [June 4, 2019, 8:42pm UTC](https://forum.inductiveautomation.com/t/percent-values-show-as-nan-if-theyre-very-small-in-number-format-table-column/25554 "2019-06-04T20:42:13Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![md.szyman](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/md.szyman/32/9240_2.png) [@md.szyman](https://forum.inductiveautomation.com/u/md.szyman)\
**Post date:** [June 4, 2019, 8:52pm UTC](https://forum.inductiveautomation.com/t/percent-values-show-as-nan-if-theyre-very-small-in-number-format-table-column/25554/2 "2019-06-04T20:52:20Z")

</div>

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/percent-values-show-as-nan-if-theyre-very-small-in-number-format-table-column/25554)._