Currency Conversion

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!

Accepted answers

This thread might help

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

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

This thread might help