2 Replies Latest reply: Jul 18, 2014 9:03 AM by Sebastian Pereira RSS

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

    Yeo Poh sai

      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.