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.

    PAUL YEO

      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