4 Replies Latest reply: Feb 14, 2018 10:32 AM by Julia Hoedemaker RSS

    Trying to convert data to USD with exchange rates

    Julia Hoedemaker

      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