Expression to see dynamic growth of Avg. Selling Price

[ronman10]

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

[ogautier62 · Accepted solution]

hi,

just a remark :

your average is sum(value) / sum(volume) no ?

which is different from sum(value/volume)

regards

[rangam_s]

The expression you have used is correct. However, you see 0 % since the previous year number is matching with current year numbers (no change).

Try with different numbers then you see the change.

Small suggestion, each and every product will have different ASP, so trying to show it by year is not correct. Use product as well as dimension then it will make more accurate.

or

Calculate ASP by product then sum it for that particular year.

Hope this helps.

[ronman10]

Hi Oliver,

This worked. Here is the expression I used. (Sum(VALUE)/Sum(VOLUME))/Above (Sum(VALUE)/Sum(VOLUME))-1

Thanks everyone for your help.

Regards,

Rony