
1. Re: Calculation Field Sum
philmodjunk Oct 16, 2014 3:14 PM (in response to Gilo)And how do the FIeld_Plus and Field_minus compute their sums? (there's more than one way)
If they are calculation fields, you should be able to just use: Field_plus  Field_minus.
But I suspect that this answer is too simple. Perhaps these two fields are summary fields and you need to compute a difference of sub totals?

2. Re: Calculation Field Sum
Gilo Oct 17, 2014 12:07 AM (in response to Gilo)Sorry, didn't give enough info, my bad...
Field_Plus is a summary field, which adds up all the values of Field_MoneyIGet.
Field_Minus is a summary field which adds up all the values of Field_MoneyISpent.So If Record 1 has 10€ in Field_MoneyIGet and Record 2 has 20€ in Field_MoneyIGet, my Field_Plus returns 30 €
On screen Field_Total = Field_Plus  Field_Minus works but If I print my report, where I have several in between results, It shows always the same value, which is also wrong.

3. Re: Calculation Field Sum
raybaudi Oct 17, 2014 2:30 AM (in response to Gilo)Please, give us your wished result ( see .png )

4. Re: Calculation Field Sum
Gilo Oct 17, 2014 3:01 AM (in response to Gilo)Hi
I found a solution, for every record I added a total, where it puts the plus as positive number and minus as negative and then I sum up and i get the difference
Thank you guys