Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to convert the sum of the daily currency converter.
In the KPI view, I need to see this sum.
examples:
I have two tabels
The first table tells about the exchange rate
Currency | USD | EUR |
2022-04-12 | 3.1108 | 4,12 |
2022-04-13 | 6.886 | 3,6 |
2022-04-14 | 6.886 | 4,2 |
2022-04-15 | 6.886 | 3,3 |
The first table tells about revenues
Table | reve |
2022-04-12 | 6000 |
2022-04-13 | 485 |
2022-04-14 | 3654 |
2022-04-15 | 415 |
Both tables are linked with the data key
how can i write the correct function?
In the table, I can do it without any problem, but it has a problem with the KPI view
Any help would be greatly appreciated.
Regards
I.
MapUSD:
Mapping Load
Date,USD
From Currentdata;
MapEUR:
Mapping Load
Date,EUR
From Currentdata
Temp:
Load
Date
,Revenue
,Applymap('MapUSD',Date,1)*Revenue as Revenue_USD
,Applymap('MapEUR',Date,1)*Revenue as Revenue_EUR
From Factdata;
OR in frontEnd
Revenue_USD:
=sum(Revenue * USD)
Revenue_EUR:
=sum(Revenue * EUR)
MapUSD:
Mapping Load
Date,USD
From Currentdata;
MapEUR:
Mapping Load
Date,EUR
From Currentdata
Temp:
Load
Date
,Revenue
,Applymap('MapUSD',Date,1)*Revenue as Revenue_USD
,Applymap('MapEUR',Date,1)*Revenue as Revenue_EUR
From Factdata;
OR in frontEnd
Revenue_USD:
=sum(Revenue * USD)
Revenue_EUR:
=sum(Revenue * EUR)