Subracting group totals

[jermine]

I have two groups, @assets and @ expenses which i have to subtract.

Group Value
@asset 2000
@expenses 1500
Total 500

I know this can be done by changing the "summarize" operation for the "grand total" value but problem arises when the @expenses becomes a negative value.

i hope you guys can help me on this, thanks!

 

[rosemaryl]

Dear jermine,

Could you please explain in a little more detail what the problem is?

You have two formula fields that have accumulated totals: Asset and Expenses, Expenses need to be subtracted from Assets and your issue is that if expenses is a negative it is ...

What result are you getting - is there an error?

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[jermine]

if the situation is :
Group Value
@asset 2000
@expenses -1500
the total becomes 3500.

 

[rosemaryl]

You would get the same value in Excel. You can test it. If you subtract (1500) from 2000 the correct answer is 3,500.

So, is what you want is regardless of whether the value is a positive or a negative treat all numbers as a positive?

What is your logic.

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.