Foreign currencies

[Hettie2102]

I have 3 currencies in a dataset, CAD, GBP and USD. How do I add a formula to convert the CAD and GBP to USD so there's one USD column.

Thanks! 

[atcodedog05]

Hi @Hettie2102 

Can you share a sample data and expected output.

[Hettie2102]

Hi, 

please see attached document, thank you!

[echuong1 · Accepted solution]

I'd start off by using a multi-row formula to add years to each individual row. You also have extra spaces and commas in your dataset, so I'd apply a data cleansing tool to clean these up. From there, you can use a join to do a "vlookup" and add in the FX rates. It is then just multiplication in a formula tool to get the GBP amount.

If you want it aggregated by year you can use a summarize tool.

[atcodedog05]

Hi @Hettie2102 

Here is a workflow for the task.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍