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

<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:42pm UTC](https://forum.inductiveautomation.com/t/percent-values-show-as-nan-if-theyre-very-small-in-number-format-table-column/25554/1 "2019-06-04T20:42:13Z")

</div>

I have a table where a column in the table is a decimal percentage. In some cases, the number is very small, on the order of 10-9 and it shows up in the table as “NaN%”. I just want the values to show up as 0% when they’re this small. Am I just not using the right format string? Or is something else the problem?

---

<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.