Using NOERR to display zero's instead of nothing
I have 2 restricted key figures in the colomns. 3rd one is a formula.
Colomn A, B and C
C= a formula:
( If colomn A =0 THEN colomn C=0 ELSE result colomn A-B)
But since colomn A is empty ( no zero amounts) , this is not working. I have tried NOERR to display zero's, but still no luck. How is it possible to show zero's instead of empty cells?
Thanks a lot.