Calculated field from multiple columns

[nlsdxb]

I want to create an "Amount Converted" field from the following

I have one column with "amount" one with "Currency" and a table that contains the "conversion rate".

what script do i write that creates "Amount Converted" that calculates "amount" * "Conversion rate" based on "Currency" column?

New to scripting so any help i can get will be appreciated 

[Antoine04]

Hello,

I guess the conversion rates are in another table ?

Could you please share an overview of the table with the rates ?

[nlsdxb]

Hello!

thanks for replying! 

[nlsdxb]

the above table has a column with "currency" which i'm using to link the two table's together 

[nlsdxb · Accepted solution]

Solution found with the help of Deepak Kurup for giving me the answer and to Abhishek Agarrwal's video on how to do the syntax.

I joined the table that contained the values and the table that contained the currency rate. Now the two are linked with a full outer join and i can now create a calculated field of Amount Converted