4 Replies Latest reply on Oct 25, 2018 12:15 AM by David Chauncy

    Compare total for this year with average of previous 10 years

    David Chauncy



      I need to calculate the percentage change of this years Total (_Total_cy) over the average of the previous 10 years.  The attached shows that I have the [_w_average] worked out and the [_Total_cy].

      I can't work out how to bring it together, i.e ([_Total_cy]-[_w_Average]/[_w_Average]. In the data the calculation would be (10-16.6)/16.6 = -0.39759.


      Thanks David