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.