problem with distinct count summary on a report using grouping

[voirin]

Hi again, I seem to have a lot of questions, and this is another!

I would like to obtain a count of the number of patients in my main report. Below I have a report showing 3 distinct patients. How do I place generate this value? My 'patient' column is set to 'suppress if duplicated'. I also set the report to group by 'starttime'. When I try and summarize the 'patient' column to 'distinct count' the number of values in its column, I get a value of 4. This is obviously because it is counting the suppressed patient value in 10:30am timeslot.

+------------+-----------+----------+
|starttime | patient | matter |
+------------+-----------+----------+
|9:55am | 3 | 45 |
+------------+-----------+----------+
|10:30am | 7 | 67 |
| | | 101 |
+------------+-----------+----------+
|11:10am | 12 | 76 |
+------------+-----------+----------+

How can I get my desired statistic summary?

Any help most appreciated!

cheers,
voirin

 

[Madawc]

If you use a running total, it can have a formula for evaluation. This could exclude the patients you are not wanting to list or count.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Madawc Williams (East Anglia, UK)