Skip to main content
cancel
Showing results for
Search instead for
Did you mean:
Contributor II

Sum of different currencies

Hello.
Here is a example of my table.

Currency

Amount
Euro33
USD11
GBP44
AUD22

How it's possible to sum these different amounts as total in EURO.
Thanks!

1 Solution

Accepted Solutions
Partner - Champion III

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...

1 Reply
Partner - Champion III

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...

Community Browser