8 Replies Latest reply: Mar 6, 2012 11:31 AM by Juan Vitantonio RSS

    Calculating Percentage Change

      Hi Experts,


      I have 6 month end data for sales. For 6 months i have defined 6 variables.I am trying to calculate month on month sales variance in the expression of a chart.


      screen shot.JPG


      I want to calculate and show the percentage change in the expression as shown above.

      Please note that my chart will 2 columns:

      1. The selected month

      2. Variance between the selected month and its previous month, in percentage.



      Hopefully I am able to make you understand what exactly I am looking for.


      Thanks in advance