How to convert currencies from euro and usd to pln?

[Kamil_Kuczynski]

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