5 Replies Latest reply: May 22, 2018 5:36 AM by Olivier GAUTIER RSS

    Expression for Growth Rates

    Ron M

      Hello Everyone,

       

      I am trying to add growth rates with respect to the Avg. Selling Price (ASP=Value/Volume) of our product, for the years 2015-2018. When I select years 2015 & 2016, I need to be able to see 2016 ASP growth over 2015 ASP and so on. The data has been entered in ascending order. I tried to apply the formula, Sum(Value/Volume)/Above(Sum(Value/Volume)) - 1, but it does not seem to be working. Is there something that I am doing wrong? Please advice.

       

      Regards,

      Rony