Summing counts of Groups

[tedi1]

Hi, I'm using CR 9. I have a report that I have created which does a distinct count on the number of record that was processed by each of our company employees (Group By on the count). I want to add a summarized total so we'll know how many record were processed totally. The problem is that a record can be processed by two employees so the total count gives out a number, which is smaller, then the one you would have got if you summarized it by hand.
For example:
Employee NoOfRec
-------- -------
1 192
5 2189
-------------------
Total 2200

My question is how can I count it so the total will give me the total is it should have been if you count it by hand (In the example 2381)?

Thanx in advance.

 

[IanWaterman]

Tedi

For you to get the figures you have given as an example you must have 2381 records, why don't you count records rather than specific orders.

Ian

 

[lbass]

You could create a formula {@addcnt} to be placed in the group (employee) footer:

whileprintingrecords;
numbervar addcnt := addcnt + distinctcount({table.recordID},{table.employee})

Then create a formula {@displayaddcnt} to be placed in the report footer:
whileprintingrecords;
numbervar addcnt;

-LB