FX Work Flow

[Arkouda]

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 

[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.

[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 

[pedrodrfaria]

Hi @Arkouda 

If you could provide more context or dummy data, if you be helpful so we can properly explain it.

But you would need to summarize and group by to get the total per month (I'm assuming you want the monthly total, if you don't just dont group by, just sum it all) then join it back in back month and calculate the variance. See the workflow below.

Pedro.

[Arkouda]

Hi Pedro 

This is what I want to accomplish input file against the alteryx calc by month 

[pedrodrfaria · Accepted solution]

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.