3 Replies Latest reply: Jun 21, 2018 8:29 AM by Ron M RSS

    Expression to see dynamic growth of Avg. Selling Price

    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. Attached is a sample  QVF where I have used one of the formulas I found in the community. Please let me know the right expression.

       

      Regards,

      Rony