P&L Table % change work for sales row but not work for exp row.

[paulyeo11]

Hi All

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.

Paul

[paulyeo11]

Enclosed my QV doc

[sebastiandperei]

Hi Paul, I can't undestand what you mean with "Exp" row... Where it is?