1 Reply Latest reply on Apr 5, 2018 1:39 PM by Patrick Van Der Hyde

# Delta Price calculation

Related to discussion Delta Price calculation: Delta Price calculation

This help very much and it is working perfectly:

Calc name - ASP Delta

ZN({ FIXED [Activity], [Product], [Year] : AVG(IF [Year]='2016' THEN ([Selling Price])/([QTY]) END) } )

-zn({ FIXED [Activity], [Product], [Year] : AVG(IF [Year]='2015' THEN ([Selling Price])/([QTY]) END) })

Supporting calcs to get the above view.

Calc Name - AVG SP 2015

ZN({ FIXED [Activity], [Product], [Year] : AVG(IF [Year]='2015' THEN ([Selling Price])/([QTY]) END) } )

Calc Name - AVG SP 2016

ZN({ FIXED [Activity], [Product], [Year] : AVG(IF [Year]='2016' THEN ([Selling Price])/([QTY]) END) } )

With the numbers provided in the example (see attached) I would like to calculate the price change which would be (AVG SP 2016 - AVG SP 2015)* QTY 2016.

In this example the result would be -11500 for Activity Desktop and Product D500. I have a similar data base and have tried below formula but is not driving the correct result:

(ZN({ FIXED [TLME KEY], [Year] : AVG(IF [Year]='2018' THEN ([2018 - Invoiced Sales EUR])/([2018 - Units]) END) } )

-zn({ FIXED [TLME KEY], [Year] : AVG(IF [Year]='2017' THEN ([2017 - Invoiced Sales EUR])/([2017 - Units]) END)}))

*(zn({ FIXED [TLME KEY], [Year] : AVG(IF [Year]='2018' THEN ([2018 - Units]) END)}))

Hope you can help !

Thank you !