Re: How to calculate the amount in total with different currency ?

Kaoru Okumura — Fri, 15 Jan 2016 21:13:05 GMT

Hi, filtering the amount with Currency would work.

1. Assuming that you can have field EuroTotal, open default value for EuroTotal

2. Select Sum from Insert Function

3. Inset field Amount. then click "Filter Data"

4. set filter as Currency = Euro

Though, in case the Expense in total is repeating table, and you really need to calculate any currency in the expense item, we need to adopt a bit more complex approach. thanks,

How to calculate the amount in total with different currency ?

Tigerchen — Wed, 16 Dec 2015 08:23:52 GMT

Dear all,

I have a question in terms of How to calculate the amount of different fields into one ?

Please see the screenshot below. I can choose between two curreny : Euro and USD.

Now I want each field with the currency of Euro or USD to show up in "4. Expenses in total" next to the field Euro or USD.

Example :

Name : Chris; Curreny : Euro; Amount : 100

Name : Jeff; Currency : Euro; Amount : 125

Name : Dan; Currency : USD; Amount : 200

Name : Jenny; Currency: USD; Amount 150

Then :

Accommodation : Currency : USD; Amount : 255

Meal : Curreny : Euro; Amount : 120

Transportation : Currency : USD; Amount : 50

4. Expenses in total (based on the example above)

Euro : 345

USD : 655

How can I manage that ? Do I need to use rules ?

Thanks a lot for any help !

Best regards,

Chris

Newbie Questions

Re: How to calculate the amount in total with different currency ?

How to calculate the amount in total with different currency ?