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

# Expression for Growth Rates

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

• ###### Re: Expression for Growth Rates

I tried to apply the formula, Sum(Value/Volume)/Above(Sum(Value/Volume)) - 1, but it does not seem to be working.

Why do you think that this isn't working? Would you be able to share more information on what you got and what you expect to see?

• ###### Re: Expression for Growth Rates

Hi Sunny,

I am attaching an image with sample excel data that I am using as I am not getting the advanced editor option to attach a qvf. I want to be able to see the ASP growth rates for the years that I select. Also, if  I am using a chart to represent the growth rates what would the dimension be? Or should the growth rates be displayed as a KPI. Please let me know how you think this can be achieved.

Regards,

Rony

• ###### Re: Expression for Growth Rates

Hi,

if you have many lines of same product for a year you can't say : sum(value/volume) for the average,

but prefer : sum(value) / sum(volume)

(average of total is not sum of average !)

• ###### Re: Expression for Growth Rates

Hi Oliver,

I tried this too but it does not seem to be working.

Rony

• ###### Re: Expression for Growth Rates

Hello Ron,

you must have only year in dimension,

in order to above() is correct

where mean = sum(revenue) / sum(volume)