Daily currency converter

[Isabelaa_123]

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.

[vinieme12 · Accepted solution]

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;

[vinieme12 · Accepted solution]

OR in frontEnd

Revenue_USD:

=sum(Revenue * USD)  

Revenue_EUR:

=sum(Revenue * EUR)