Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression that calculates a value in USD and I would like to convert this to EUR based on the current day exchange rate (this data is held within our system).
The fields are:
curr_cd
exchange_date
exchange_rt
I thought I could add the following expression field to my Table, however this does not work:
IF(exchange_date='12/02/2014' AND curr_cd='EUR',exchange_rt)
Basically I want to either add a column showing today's EUR exchange rate.
Any help would be much appreciated.
Regards,
Daniel
Hope this link will help you
Hi Daniel
is your date used as a dimension in your graph ?
if so sum(values * exchangert) should work
if not
sum(values) * avg(exchange_rt) would take the average of exchange_rt for all selected date
if you want to apply only last exchange_rt to all values
sum(values) * aggr(exchanger_rt, max(date))
best regards
Chris