sum for grouping with condition

[snoopyyu]

Hi,

My report has the following columns:
BillDate, Invoice, Client, Matter, Fees, Costs, Age

My report is grouped by the &quot;Age&quot; field in my database. For each group, I need to get the sum(Fees) where invoice < 0 and the sum(Fees) where invoice > 0. Any ideas on how can I do it? Thanks in advance.

 

[vidru]

Create two running totals:

//#NegativeInvoices
if {table.invoice} < 0 then
(table.invoiced}
else
0

//#PositiveInvoices
if {table.invoice} > 0 then
(table.invoiced}
else
0

Set them both to reset on change of group Age.

-dave