Hi.
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,
CASE
WHEN account_name = "name1" THEN Amount spent * 4.65
WHEN account_name = "name2" THEN Amount spent * 4.20
END
but it doesn’t count life exchange currencies so it’s another problem.
Thanks