So to jump directly to the case, what I want to achieve is calculating the currency difference impact from 1 year to another.
CHF: domestique currency
EUR, GBP,…: Foreign currencies
The concept is the following: I calculate the Total CHF sales amount with this formula and it works.
Now what I need to do is recalculate this CHF amount but this time using the previous year currencies. At the moment I was not able to create this measures since the previous formula is using lookup to select the date and currency it has to aply for converting foreign currencies to CHF.
One I’ll have this, it is straight forward has I will only have to substract 1 formula by the oder.
Any ideas I guess this topic could interest more than 1 person in the Finance field.