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

# Get current exchange rates calculated for usd

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 0.35 12135 * 0.25 12135 * 0.45 Country A 2/20/2017 13,728 0.4 13728*0.40 13728*0.45 Country A 2/21/2017 14,213 0.45 14213*0.45 14213*0.45 Country A 2/19/2016 11,165 0.35 11165 * 0.35 11165 * 0.45 Country A 2/20/2016 7,861 0.35 7861 * 0.35 7861 * 0.45 Country A 2/21/2016 14,371 0.5 14371 * 0.50 14371 * 0.45

Thank You

• ###### 1. Re: Get current exchange rates calculated for usd

Hi Akshay,

I used a Table calculation in my workbook  MAX([Date])==TOTAL(MAX([Date])). when this true you will get the latest date.

Please look into this thread for another workaround by Mr.Jonathan Drummey. Show Only Values From Max Date in Dataset

• ###### 2. Re: Get current exchange rates calculated for usd

Hi Davuluru, Thank you for your quick response..

I believe i did not explain correctly. Apologize

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

 Name Date Local amount exchange rate in table usd amount Output needed Country A 2/19/2017 12,135 0.35 12135 * 0.25 12135 * 0.45 Country A 2/20/2017 13,728 0.4 13728*0.40 13728*0.45 Country A 2/21/2017 14,213 0.45 14213*0.45 14213*0.45 Country A 2/19/2016 11,165 0.35 11165 * 0.35 11165 * 0.45 Country A 2/20/2016 7,861 0.35 7861 * 0.35 7861 * 0.45 Country A 2/21/2016 14,371 0.5 14371 * 0.50 14371 * 0.45

Please let me know if you need more examples

Thank you so much,

Akshay

• ###### 3. Re: Get current exchange rates calculated for usd

Hi Akshay,

I'm needing almost exactly this. Would you please share how did you solve this situtation?

Thanks!