Foreign Currency Calculations assistance

[Arkouda]

Hi Community 

I raised this before but need some assistance with my work flow and outcome - 

Input:

2 Excel Files 

1) System FX calculations which provides the transactioanl currency by month and calcualted at USD_Forecast

2) Current FX Rates by month 

What I'm looking for in the output is using the Input FX file transactional currencies and validating the FX rates are calculating correctly against the system calculated FX USD_Forecast. 

Attached is my work flow in which I have attempted to build and had assistance from this community (appreciate the support from others) but I'm running into a road block. While it is easy via Excel but Alteryx is the key 

My output results is to have the FX rates calculated the input currency which should equal the USD_Forcecast by month 

i.e. CAD * CAD Rate USD = XXX

USD_Forecast= XXX

 No Variance by month (hopefully)

Thank you for those who look into this and will provide additional info if needed 

Arkouda 

[AngelosPachis · Accepted solution]

Hi @Arkouda ,

Maybe this workflow works for you?

It seems you have some variance for some months

[Arkouda]

Thank you Angelo - this has worked and the output was that I was looking for - the Rates are not update for full year (just the 9 months) thus creating variances in OCt, Nov & Dec

George Vlioras