Removing "NaN points" from graphs or formula to avoid "NaN" results [message #1734] |
Mon, 12 September 2022 13:48 |
Charlene
Messages: 2 Registered: September 2022
|
Junior Member |
|
|
Dear team,
First of all, thanks a lot for this useful forum, I already found answers to my questions in the previous topics!
However I was not able to find an answer to this issue that I encountered:
- I added calculated values with some formula from different columns. However, in these columns, some rows do not have values and are empty, therefore the calculation gave "NaN"
- The problem is that when I draw a 2D graph, the "NaN" values are also reported on the graph as "0" all on the bottom which is not useful.
My questions are:
- is there a function like there is on excel which allows to get an empty box if the result of the calculation is 0?
- and/or is it possible to remove all the "NaN" points from the graphs?
Many thanks in advance for your return,
Kind regards,
Charlène
|
|
|
|
|