Currency Conversion

[jboschee]

Hi everyone,

I'm trying to do some currency conversions and I think I'm missing a step.

I need my formula to look at what the current currency is, then look at the conversion table and pick the rate need and then do the calculation.

Thanks in advance!

[gnans19]

@jboschee

I think a simple join between your data and conversion table would do the trick. Assuming you have corrency code in both the tables.

[jboschee]

I have currency in both going in to the join.  My formula after the join in what is not working.

[gnans19]

Check for data type. Can you please attach screenshot to help further?

[cmcclellan · Accepted solution]

This thread might help :)

https://community.alteryx.com/t5/Data-Preparation-Blending/Create-computed-field-with-multiple-IF-s-...