Totals of COUNT fields

[dadoggh]

I am working on a call center program. Each call generates a call number. Calls are categorized as "Open" or "Closed". I have two groups set up - the first one groups the calls by employees. The second one groups the calls by being either "Open" or "Closed". I can get the total number of "Open" or "Closed" calls to come out for each user by using the COUNT command. I would like to get a Grand Total number of "Open" and "Closed" calls. Here is what I would like to have come out:

Employee #1
Open Calls: 2 (count field)
Closed Calls: 4 (count field)

Thank you in advance for all of your help!!!

Employee #2
Open Calls: 1 (count field)
Closed Calls: 2 (count field)

-----------------------------------
Totals
-----------------------------------
Open Calls: 3
Closed Calls: 6
-----------------------------------

What would be the best way for me to get the Total number of Calls sorted by "Open" or "Closed"?

 

[synapsevampire]

If you don't need to have a group for "Open" or "Closed", you could just create 2 formulas, one for each as in:
//Open
if {MyTable.CallType} = "Open" then 1
else
0

//Closed
if {MyTable.CallType} = "Closed" then 1
else
0

Drop each of these formulas into the detail band, right click them and select insert summary->Count and select for all groups and Insert Grand Totals.

Now you can delete the formulas from the details section.

Another means, that I assume leverages your existing methodology, is to create a Running Total for each, with the criteria for what constitutes a Open or Closed in the Evaluate->Use a Formula area (you didn't share how this is determined).

Hope that handles it for you.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com