In a compare table and/or pivot table where I've added some formula fields, is there a way to set null values to zero instead of blanks?
In screen shot #1 attached I have a filter on column "H" and in some reporting quarters I don't have any rows matching that filter criteria. Column K is just a sum of columns H, I, and J. However, my formula in column K doesn't calculate properly on the rows where there's a blank in column H.
How do I set column "H" to zero instead of blank which will then allow column "K" to calculate properly?
Thank you!
-MG
3 answers
