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 !
Hello Henar,
Do you have a packaged workbook to share the example calculation with us? Packaged workbooks and flows: when, why, how
Please be sure to tell us the version of Tableau Desktop in use as well.
Regards
Patrick
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.