I have 3 years monthly sales history and have a monthly EUR/USD/GBP exchange rate. I have an Input Box that allows the user to choose the currency and then calculates the value based on this. I can get this to work for the monthly totals but not for the year. I think I have to use the Aggr function but cant get it to work.
Here is the expression, what am I missing?
=(Sum(Sales)*if(vCurrency='EUR',[Rate EUR],if(vCurrency='USD',[Rate USD],1),MONTH_YEAR,Year) )
Sales and the monthly FX Rate are aligned to MONTH_YEAR.
TIA.