FILTERING NaN

Question

Hi AllHelp required as below. Thanks and Happy New Year.

Werner_E · Accepted Answer

> They will not occur in beween valid numbers.

Where the Nan's are in a column does not matter at all. The buitl-in function "filterNaN" throws an error on two situations:

1) no NaN in the matrix (thats silly as it just should return the original matrix unchanged) this is fixed by my first attempt above

2) NaN is in every row of the matrix. Here we would expect an empty matrix but thats something not provided by Prime. My last two attempts try to fix this by returning NaN instead of a matrix.

in your case you could write a program with a loop that counts and stops when the first value in a column is not a scalar. But as along as the column contains at least one scalar, my short first rewrite of "filterNan" should do the job.

Werner_E · Answer

Simply write your own, modified "filterNaN" using try and catch

Note, that you may still run into problems if the argument contains a NaN in every row. You will get back the argument unmodified. Thats no along the logic of the function as you should get back kind of an empty matrix (which unfortunately does not exist in Prime).

In your pic you write that you expect 0 as a result. I guess you'd rather expect a return value of 19!

BTW, I guess you were already told in other threads, ALWAYS include your worksheet if ever possible! If the sheet contains sensible data you are not allowed to share, create a demo worksheet without that data but still showing the problem.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded