Count a field subject to a condition

[Katy44]

Hi,
I am using Crystal 9.
I have inserted summary fields to count the number of records in my report. I then want another summary field alongside to show the number of records where a particular field has the value 1.
I can think of two ways of doing this: first to group by this field, choose to customise my groups, have one group for the "1" records and group all the others together and then put a count on the group headers.
The other way would be to create a formula to output 1 if the value of the field is "1", or zero otherwise, and then sum on this.
These are both fine, and I assume they would work, but they seem a very roundabout way of doing something very simple. Am I missing something obvious?

 

[Reebo99]

No, your not missing anything obvious. The options you have shown are the easiest.

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[Katy44]

OK, thank you. I have done it the second way.
I would have thought there would be a conditional sum, conditional count etc option, where you insert a summary for records that meet your specified criteria. Oh well, thanks for your help.

 

[Reebo99]

That would be a running total, which would also work.

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.