Print Page | Close Window

count of group items > 0

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4282
Printed Date: 02 May 2024 at 6:21pm


Topic: count of group items > 0
Posted By: Harleyquin
Subject: count of group items > 0
Date Posted: 17 Sep 2008 at 6:30am

Sum a group total.

I have created groups, some have totals and some don’t

Etc

North Sector Group

GP1                        1

GP2                        0

GP3                        13 

South Sector Croup

GP1                        0

GP2                        2

What I’m after is a result something like this:

North Sector Group   - 3 Areas, 2 Areas >0 , 14 items

South Sector Group – 2 areas, 1 Area >0, 2 items.
 
I cannot do a simple sum as each group has many values which I sum up to give the group total. I’ve tried “if GP>0 then 1 else 0” – but I cannot then sum this up further on...
 
Effectively the bit I’m falling over on is to get a count of the groups where Items are > 0


Print Page | Close Window