Currency convertor

[Hussein982]

Hi all:

I have a very simple question. I have a table (see below) with invoices that are in different currencies. I would like to convert all invoice amount into CAD currency and have them all into the converted amount column.

How can I do that using the formula tool or any other tool. 

Appreciate your help.

Country	invoice #	Invoice amount	invoice currency	Converted currency	Converted amount
Canada	1	1000	CAD	CAD
USD	2	2000	USD	CAD
West africa	3	3000	CFA	CAD

[Emil_Kos]

Hi @Hussein982,

You need to use the find and replace a tool or join tool and bring up the currency converter.

So basically you need to have a mapping table and then you need to use the formula tool to multiply the data. 

[Hussein982]

Thanks @Emil_Kos  for your quick response. I appreciate if you could share with me the workflow based on the example/table I shared earlier. 

Thank you for your help in advance. 

[Emil_Kos · Accepted solution]

Hi @Hussein982,

Please find the workflow attached: