Trying to convert data to USD with exchange rates

[Anonymous]

I am in the process of trying to convert my data with USD Average Rate.

Currently I have 3 tables that connect. These are what each excel sheet contains

1. Entity Code and Amount

2. Exchange rate and Entity Code

3. Date and Exchange rate.

I am not sure what function to use, but I want to convert the amount into USD through the data load editor. Currently right now my data shows the amounts in function currency. Those currencies range from variance currencies. I need to convert the numbers on excel sheet 1 to USD. I would like some feedback on how to convert the amounts.

Thanks!

Julia

[ychaitanya]

Hi Julia

Please upload an excel sheet or sample data to provide the solution.

Thanks

CY

[rwunderlich]

Assuming the amounts in sheet1 are not sensitive to Date, try something like this:

ExchangeMap:

MAPPING LOAD EntityCode, ExchangeRate

FROM ....(sheet is sheet2$);     // Load map from Sheet2

Sheet1:

LOAD

     EntityCode,

     Amount,

      ApplyMap('ExchangeMap', EntityCode, 1) * Amount as AmountLC

FROM ....(sheet is sheet1$);

-Rob

[Anonymous]

I have uploaded sample files. I need to convert the amount in 'amount' file from CAD to USD. This is just an example, but in my master file there are multiple currency codes I need to convert.

[Anonymous]

The sheet is date sensitive. I have uploaded sample files for reference.