Print Page | Close Window

counts in headers

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=2748
Printed Date: 06 May 2024 at 5:43pm


Topic: counts in headers
Posted By: arclight
Subject: counts in headers
Date Posted: 28 Mar 2008 at 9:42am
I am working on a status report where there is a summary of wins/ losses. etc. in a group header. That part was easy, I created a if ..then 1 else 0 formula and summed the formula. The problem is I need to do a percentage of these counts to the total records in the group. I can't seem to get the summary into the formula to do the percent calculation. When I try to pull a summary into the formula it generates an error "There must be a group that matches this field"
 
Any suggestions would be appreciated.
 
 


Replies:
Posted By: hilfy
Date Posted: 28 Mar 2008 at 9:53am

Please post the formula you tried to use.  With that I can see what might be wrong and suggest some corrections.

Also, when you use summary functions (sum, count, etc.) in your formula, the format is like this:
 
sum({field/formula being summed}, {group field or formula})
 
"{group field or formula}" is optional.  If it's not used, then you get the grand totals for the report.  If it is used, you MUST use a field or formula that you've set a group on.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window