Skip to Content
0
Former Member
Apr 27, 2014 at 01:02 AM

Distinct Count Help

25 Views

Okay I have 3 fields for call records : On call & Daily Assignment to indicate the service level when the call came in. The 3rd field displays the assignment duration of the call in HH:MM:

I need to find a way to show the count of the calls where

A- Count of on call records that exceed 4 hours (assignment duration) compared to all on call records

B - Count of daily assignment records that exceed 2 hours (assignment duration) compared to all daily assignment records

Attachments

Crystal.jpg (315.7 kB)