FX Work Flow

Hi Alteryx Community

I have built a work flow where I have taken 2 input files

1) is the currencies by month and total USD_Forecast

2) is the FX rates by month Balance

Outcome

I want to validate the the transactional currencies and recalculate these values by using the FX Rates and validating this against the USD_Forecast value by month but running into Type issues.

I have attached my current work flow for review as well as the input files

thank you

FX Rate Conversion-1.yxmd

FX Rates.xlsx

Input FX.xlsx

Input

Accepted answers

pedrodrfaria

Hi @Arkouda

It is kinda hard to piece it all together of what you are trying to do. But I'm pretty sure this workflow will help you get to the point you are trying to get.

I updated the workflow to consider the data input you have. I didn't add everything because it would be a lot to type out, but you can add the data input on your end and see if makes sense.

This filter right here can be deleted, I was just filtering to see how the data moves along the workflow

I recommend you to double check to see if both formula tools in the workflow are doing exactly what you are trying to accomplish.

Pedro.

FX Rate Conversion-1.yxmd

All comments

pedrodrfaria

Hi @Arkouda

I'm not really sure what you are trying to compare these values with. After joining and calculating the value, what are we comparing these amounts to?

I added the workflow for reference.

Pedro.

FX Rate Conversion-1.yxmd

Arkouda

Hi Pedro

Thank you for the quick response

I was going to add another variance to calculate the Sum of the calculated to USD to the USD_Forecast

do you know how I will do this so it can calculate it by month

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703