Conversion of currency from $ to EUR

[cocobello3]

Hi all,

I would like to calculate EUR column from one table with $ values and a conversion table. How can I do this calculation?

Thanks for your help and best regards,

[Or · Accepted solution]

If you simply load these two tables, they will automatically join based on Period and Senario and you should be able to use the formula [$]/[$ / EUR].

You could also elect to JOIN these two tables, since there doesn't seem to be any reason to keep them separate.

Load * From Table1;

LEFT JOIN

Load * From Table2;

[cocobello3]

Thanks for your help !