Skip to Content
0
Former Member
Jun 12, 2009 at 04:41 PM

Running Totals Calculation

29 Views

I have report set up that pulls account ID's and breaks them up by their associated process. Each ID can have any number of items associated with it (there are generally 1 to 5 items per ID).

I need to be able to break out the oldest aged item by ID and put it into a age bucket (0-4 days, 5-9 days, etc.) by process to count the number of aged ID's (oldest item) for each bucket with grand totals for all of the buckets.

I feel like I'm close to getting the desired results, but I can't seem to get the running totals to count the oldest aged item by ID. No matter what I try, the running total always counts the all of the items instead of the oldest item by ID.

Any suggestions on how to make this work would be greatly appreciated.