Writing formula with boolean operators
I need to write a formula that will, for a key figure, recognize if the cell is blank and if so convert it to zero. So for example,
if (keyfig = ' ') , then (keyfig = '0')
How do I do this using the boolean operators supplied to us for writing formulas and calculated key figures????
Try the below formula in your report.
(KF == 0)*0