How to sum distinct Count

building reports crystal reports
1

Hi Gurus,
I had created a formula in Crystal Report.
Employee Count = distinctcount({Employee Name},{States}).
This is displaying correctly by States.
VA=100
CA=500
FL=300

How to display Total sum of Employee Count (900) on the report footer?

Philip (BOB member since 2006-03-02)

2

just perform ordinary count by to get the total count of the employees

count({Employee Name}),{

[/code]

nahtanoj :philippines: (BOB member since 2009-07-08)

3

Ordinary count is not working here. Some reason it is displaying last row value on Total field. In my case 300 is showing instead of 900 in RF. Please help…

Philip (BOB member since 2006-03-02)

4

Hi Philip,

First insert distinct count on {Employee Name} and place this in {States} group footer then insert count on {Employee Name) and place this in Report footer.

Note : Use Insert Summary option in CR to insert distinct count and count in group footer and report footer respectively.

siva6809 (BOB member since 2009-03-05)

5

hi,
CR does not support any functions like sum, Max, etc once you created formula using count or distinctcount. Example sum(count(Employee name)) does not support…

Philip (BOB member since 2006-03-02)

6

Do it on field not on formula.

siva6809 (BOB member since 2009-03-05)