Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 3 files with data in multiple currencies and 1 file with the Currency Rates.
I would like to have the script to look at the Currency field in the data table(s), find the corresponding Rate in the Currency Table and calculate the Euro rate, the have the result of that calculation show up as a column.
I'm still pretty new at this, so can anyone give me some pointers on how to do this? So far, all my attempts have failed.
Would be much appreciated.
Check this: Currency Conversion
If you have the Currency rate on each day, just add the currency rate based on your transaction date with ApplyMap.
Please post some sample data