I am trying to connect a table with data in country's currencies with a table with exchange rates, aiming to produce a final table with figures both in local and converted (EUR) values. The tables look similar to this:
Obviously, when calculating the figures, the script should take into account the correct exchange rate for the particular country, and also skip countries which already use EUR. The third table (or maybe append to the 1st one) I am aiming to produce should look something like this:
Re: Converting figures from native currencies to EUR
This is a great idea but i don't think it will suit my needs. I would like to have the figures already calculated in the script, as in my case it won't be efficient to have the calculations in the charts.