Remove NaN

[nyp123]

How do i remove the NaN in "output/input" array. Also i need to display the top column of "200077670" array like "2000776729".

[P@Anand]

When you divide a 0 by 0 it will give you NaN. Check the values coming in the denominator is a non-zero value since you are trying to calculate percentage (I Guess).

Good Luck.

[nyp123]

Some of my denominator has values. Is it possible to display it in "0" instead of NaN for both non values and with values? 

[P@Anand]

yes you have to check the values as NaN if true pass 0 else pass the value. You can perform this inside the for loop.

[nyp123]

something like this?? not very good in this...new to LV

[TiTou]

I use this to remove NaN from my arrays, hope this helps.

[nyp123]

Thanks that was good but i am required to show the "0" array instead of removing it

[TiTou]

well then just replace the "delete from array" primitive with a "replace array subset primitive" or better with an inplace structure.

[P@Anand · Accepted solution]

I generally use the following method. 1st one replace the NaN with 0 and the 2nd removes the NaN.

Good Luck.

[TiTou]

you'd be slower on large arrays 😛