Converting Data using FX Rates

[AlteryxLearner23]

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.

[Raj]

can you help with the logic used

[Raj]

do you want to multiply the each value according to the exchange rate from rate sheet into output sheet or there is a input sheet which after transformation should look like output sheet?

[geraldo]

@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

[AlteryxLearner23]

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]

@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