How to replace "NaN" with Zero value

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 … :slight_smile: … I converted the Numbers to String, replaced the “NaN” with “0” value, then converted the String list to Numbers.

1 Like