3 Replies Latest reply on Nov 30, 2018 12:47 PM by Daniel de Amilivia

    Get current exchange rates calculated for usd

    Akshay A

      Hi All,

       

      We have a table that stores exchange rates for an year for all countries..The dataset includes 2015 to current data and user wants to get a constant rate calculated across all years per country

      Is it possible to calculate the usd amount for all years either based on 1st day of current month & year OR current date

      Attached the workbook for reference

       

      Please see highlighted Output needed column I basically need constant exchange rate for each country across all dates.

      My data set to be displayed is for 2 years and need to multiply the local amount by the current exchange rate value stored in the warehouse.

      In below example current date is 2/21 hence rate will be picked from 2/21/17 and applied across all years to multiply local

       

      If current rate is not possible then i can also calculate using the first day of the month

       

       

      Name

      Date

      Local amount

      exchange rate in table

      usd amount

      Output needed

      Country A

      2/19/2017

      12,135

      1. 0.35

      12135 * 0.25

      12135 * 0.45

      Country A

      2/20/2017

      13,728

      1. 0.4

      13728*0.40

      13728*0.45

      Country A

      2/21/2017

      14,213

      1. 0.45

      14213*0.45

      14213*0.45

       

       

       

       

       

       

      Country A

      2/19/2016

      11,165

      1. 0.35

      11165 * 0.35

      11165 * 0.45

      Country A

      2/20/2016

      7,861

      1. 0.35

      7861 * 0.35

      7861 * 0.45

      Country A

      2/21/2016

      14,371

      1. 0.5

      14371 * 0.50

      14371 * 0.45

       

      Thank You