Currency convertor

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

Preparation

Accepted answers

Emil_Kos

Hi @Hussein982,

Please find the workflow attached:

Currency.yxmd

All comments

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703