you can either
1. create formulas to do this
2. create variable formulas
3. Create Running totals
The easiest for the sample data given is option #1.
Create a formula named "Positive"
if field<0 then 0 else field
SUM the formula field
Create a formual named "Negative"
if field >0 then 0 else field
SUM the formula field
Edited by DBlank - 31 Aug 2010 at 7:05am