Formula to count records where field is a particular value

[adrianval]

Hi,
im fairly new to crystal reports. I know how to create simple formulas, but have been unable to create a formula
which counts the number of records where a field has a particular value.

in SQL it would read: select count(*) from status
where status = "FINISHED"

ive been searching everywhere, even 'Crystal Reports for Dummies'. Help pleaseee someone. ))

 

[AndrewBaines]

If you're using 8 or 8.5, you can use a running total field and only evaluate on your condition. Andrew Baines
Chase International

 

[kenhamady]

This and other techniques are described in faq149-243 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com