Creating Two Totals on One Field

[matthoward]

Hey, Does anyone have an idea on how to create two totals on one field? My situation is that I have a field that contains negative and positive values and I want to do a total of the negative and a total of the positive. for example
New Motors Ltd -$100
Motor Cars Ltd $300
Crash Bang Motors $125
Drive By Cars Ltd -$50
Pedal to the Metal Motors -$200
Total Negative Balance is -$350
Total Positive Balance is $425

Thanks in Advance for all your help,

Regards,

Matt

 

[Naith]

You can do a conditional running total, set to sum. Click on the formula button, and apply the condition < 0.

Repeat the process for => 0.

Naith