10 Replies Latest reply on Jun 28, 2018 4:43 PM by Shinichiro Murakami

    Referencing exchange rates in different years

    Jon Boschee

      Hi everyone,

       

      I'm trying to calculate sales in USD from local currency.  The issue I'm running into is 1 country happens to have 2 exchange rates

       

      Here's an example of the rates:

        

      BulgariaEUR20150.78
      BulgariaEUR20160.91
      BulgariaEUR20170.92
      BulgariaEUR20180.86
      BulgariaBGN20151.5359
      BulgariaBGN20161.77
      BulgariaBGN20171.793
      BulgariaBGN20181.6787

       

      The issue is that all sales from 2015-2017 are in EUR and all sales in 2018 are in BGN.    I want to be able to look at the 2017 sales (EUR) in the 2018 exchange rate (BGN).  If I select these parameters, nothing comes up.   I need to find a way to have it recognize the sales in 2017 are in EUR and use the 2018 EUR exchange rate for the conversion.

       

      If anyone has any ideas, I'd greatly appreciate it!