Click here to Skip to main content
15,886,873 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a report that looks at turn around times for cases. Each case has multiple parts. I want to sum the times, but only for those cases with 2 or less parts.
Because the field to denote less than 3 parts is a summary field, I can't use it as the condition for a running total or other summary.
Thoughts on how to crack this?

For example,
case123 20min partA
case123 22min partB
sum of rec-call is 42

case558 20min partA
case558 20min partB
case558 20min partC
sum of rec-call is 60
I want to sum up all the totals for only those that have <3 parts. Since the sum is calculated at the group level, it won't let me choose that field.

What I have tried:

Running totals, formulas and summaries of various means
Posted
Updated 19-Sep-18 23:41pm

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900