I have column that are created from the IF formula which returns the ""
values if the result is false. I can't use NA() instead because then, I am
using these columns for other calculations such as average.
I need to use those columns also to create charts, but my lines with "" are
showing zero values.

I read in this forum that we can use a trick solution: to have a column
using "" for the calculation and another using NA() for the graph. If I have
too many coumns, is there an easier way to solve it?
Thank,