0 Replies Latest reply: Oct 10, 2014 6:03 AM by Dermot mcgoldrick RSS

    Rolling up historical Monthly FX rates

    Dermot mcgoldrick

      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.