Newbie problem with conditional running total

[Goalie3533]

I have a report that lists all of the payments by all of our clients. If the payment is a positive amount, it means the company paid it's bill and everything's fine. If the payment is a negative number however, it means the check bounced.

Now my company wants to see the total dollar amount of all the bounced checks for each client. I know how to create a simple running total but not one that filters out only the negative amounts and displays them on the screen.

How can I go about doing this?

Thanks in advance.

-Goalie35

 

[lbass]

I would try using a formula first:

if {table.payment} < 0 then {table.payment}

Then right click on this formula and insert a summary->sum.

If you need to use running totals for some reason, then choose {table.payment}, sum, evaluate using a formula:

{table.payment} < 0

Reset on change of group (client).

-LB