8 Replies Latest reply: Sep 18, 2010 1:01 PM by Michael Solomovich RSS

    Need help in the expression calculation

      Hi All,

      I am using the below code in the expression in one of my pivot table to calculate growth but whenever column(1) is 0 it doesn't work as it should be. I know this will not work whenever the column(1) is zero. So let me know what changes has to be done in the expression to make it work.

       

      (column(2)-column(1))/column(1)


      Thanks and Regards,

      Rikab Kothari