I need to convert multi currencies from EUR and USD to pln. Data are in table.
For example first row is in PLN, the second is USD and the third is in eur. I want convert all these currencies to PLN in converted column. How to do it?
This is my code,
WHEN account_name = "name1" THEN Amount spent * 4.65
WHEN account_name = "name2" THEN Amount spent * 4.20
but it doesn’t count life exchange currencies so it’s another problem.