Converting Data using FX Rates

Question

Hi,

I'm trying to convert some data using FX rates.

In the file attached, 'Output2' tab shows the data I'm trying to convert.

The tab 'Rate' shows the rate that corresponds for each month.

How do I do this?

The currency to use can be found in Column E of the 'Output2' tab.

For example, I want to convert row 1 using the GBP currency in the 'Rate' tab for each month and each month's corresponding rate.

Book3456.xlsx

geraldo · Answer

@AlteryxLearner23

In the header of the files I had to make an adjustment. In one file it is as a string and in another it is formatted as a date.
and I also had to review the values ??that were apparently string

AlteryxLearner23 · Answer

Thanks!

I can see that it works for Jan-23 conversion, but all the other conversion columns are empty. How can I populate the others like 'Jan-23_Conv'?

geraldo · Answer

@AlteryxLearner23

An example workflow and macro follows.
The conversion is done by multiplying the values. If not, just adjust the calculation in the macro.
Any questions just ask

ConvertData.yxzp