Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
Here is a example of my table.
Currency | Amount |
---|---|
Euro | 33 |
USD | 11 |
GBP | 44 |
AUD | 22 |
How it's possible to sum these different amounts as total in EURO.
Thanks!
You can create a currency exchange table and then simply multiply by the exchange rate.
AMOUNTS:
LOAD * INLINE [
Currency, Amount
EUR,33
USD,11
GBP,44
AUD,22
];
CURRXCHANGE:
LOAD * INLINE [
Currency, xRate
EUR, 1
USD, 1.1
GBP, 1.3
AUD, 2.6
];
In a table in a sheet in your application you could have an expression like this:
Sum( Amount ) * xRate
and have the dimension: Currency.
This is an overly simplistic example but it is basically this approach...
You can create a currency exchange table and then simply multiply by the exchange rate.
AMOUNTS:
LOAD * INLINE [
Currency, Amount
EUR,33
USD,11
GBP,44
AUD,22
];
CURRXCHANGE:
LOAD * INLINE [
Currency, xRate
EUR, 1
USD, 1.1
GBP, 1.3
AUD, 2.6
];
In a table in a sheet in your application you could have an expression like this:
Sum( Amount ) * xRate
and have the dimension: Currency.
This is an overly simplistic example but it is basically this approach...