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

    Delta Price calculation

    henar.alonsoespinaco.0

      Related to discussion Delta Price calculation: Delta Price calculation

       

      Can you please advise how to calculate PRICE CHANGE ?

       

      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 !