How can I replace or swap the “NaN” value in this list with “Zero” number.
Thank you.
I think 1/0 returns nan… that or 0/1…
Once you figure out how to return it quickly you can define it in a a code block as a variable, and use that for a simple if statement replacement. Something like this:
nan = 1/0;
a==nan? 0:a;
2 Likes
Thank you @jacob.small … this was helpful.
I also tried it a different way … … I converted the Numbers to String, replaced the “NaN” with “0” value, then converted the String list to Numbers.
1 Like