Thanks for your reply.
At the line level it is okay, but not at the activity level.
It works, until we have some material we sold in a year but not the other.
Attached a revised workbook where I have added 1 new product (Product Launch) with some numbers.
The result should be the same than your previous version in fact, meaning, if not matching both years, we cannot calculate the Delta Price.
I had a similar post 9 months ago that we just solved. (But a bit complex)
May be you know an easier way.
I don't see any attachments with your recent reply,
so I just added rows for both new and discontinued products.
So you want to count for only those products
which are present in both 2016 and 2017 --
throwing both new and discontinued ones
out from the calculation? This could be done.
Please find the attached w/modifications.
Delta Price test_mod_YF.twbx 75.8 KB
Thanks Yuri !
I still find some differences there and there, but it is probably in my methodology (I remove the lines where the Turnover is 0 even if there is quantity).
But this is an old formula, that might need to be corrected from my side.
I'll double check and let you know if any further differences.