Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CountIF in Crystal
- Thread starter kg2report
- Start date
You do it in two steps in Crystal. First write a formula like this:
if [Criteria]
then 1
else 0
You create your ranges by grouping the records into the groups to match your ranges. Then you do a Sum grand total and/or a Sum group total of this formula. Yes, you do a SUM even though you want a count.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
if [Criteria]
then 1
else 0
You create your ranges by grouping the records into the groups to match your ranges. Then you do a Sum grand total and/or a Sum group total of this formula. Yes, you do a SUM even though you want a count.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
- Status
Similar threads
- Locked
- Question
- Locked
- Question