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