I have following Data

Age     Pat_ID     Balance     Owner
326.00     1001     399.00     5,502
326.00     1001     399.00     5,502
326.00     1001     399.00     5,502
239.00     2002     1,110.005,502
239.00     2022     1,110.005,502
239.00     2002     1,110.005,502
500     3003    2000     5505

I need a Total of 1509 for owner 5502 and age > 4,2000 for ownder 5005 and age > 6.I am using running totals for this

Fields to Summarize --> Balance
Tyoe of Summary -- > Sum
Evaluate --> Use formula owner = 5502 and age > 4
Reset --> Never

However I am not getting the desired Result.Age criteria needs to be there cuz There are some records which has age < 4.Please help.

Thanks,


Edited by achandana01 - 25 Oct 2012 at 1:00pm

Thank you but what about Age field how do I age as a criteria in RT?

Edited by achandana01 - 26 Oct 2012 at 9:02am

Your RT design looks fine...where did you place the Running Total on the report? RT's must be on or below that last row of data that is included in the evaluation (they dont work in headers).