Skip to Content
0
Former Member
Feb 27, 2009 at 07:55 PM

Sum Running Totals

32 Views

I have these sample data in my report:

Car License No of Cases

133ABC 23

234EDG 15

456YUI 1

428UYT 2

897ERT 1

The number of cases are running totals based on some criteria. Now I need to count how many licenses plates that have more than 1 cases and the total number of cases. I suppressed those record with 1 case in the group, but my running totals for number of license and cases in the report footer include them.

How should I correct these problem? There is no option for me to do a condition filter based on an existing running total.

Thanks!

Deanna

Edited by: Deanna Wang on Feb 27, 2009 8:55 PM