Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an excel data from 2015 until now (daily exchange rates) where you have from currency and to currency. To currency is always USD. I have another set of data that I am converting into USD. The problems comes when the transaction currency is USD and it is of course missing from my daily exchange rates as it would be 1. How can I add this to my data. I tried following after joining the two datasets together:
num(If(transaction_currency = 'USD', conversion_rate = '1', conversion_rate),'#,####') as new_conversion_rate
But still says for the USD transaction that the conversion rate is 0.
Anyone?
Thanks
Johanna
You could try it in this way:
num(alt(conversion_rate, 1),'#,####') as new_conversion_rate
- Marcus