This content has been marked as final. Show 2 replies
I have a P&L table . when i compute the % diff for column 1 vs column 2 .
Using below expression :-
=If(Column(1)=0 and Column(2)<>0,1,(Column(2)-Column(1))/(Column(1)))
it work fine for sales row , but it does not work for Exp row.
When i modify the above expression , to make the Exp row correct , but the sales row will be wrong.