[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

Field cannot be summarized

In my report I have to get a count of the number of people who have a 75% completion rate for attending a class.  I am grouping on the ID number of the attendee.  I also have group calculations that
sums the number of sessions attended (Sum of Total Attended).  
I have a (count of total sessions registered)
And I have a Completion formula (@complete)
Sum ({@Total Attended}, {Agency_Participant.Participant_ID})/ Count ({Agency_Attendance.Session_Number}, {Agency_Participant.Participant_ID})  

I need a count of the people who have a completion rate at 75% or grater, but when I try to use this in a formula I get the (this field cannot be summarized error message.

I have tried to use the if @complete >.75 then
1
else
0

But I also cannot summarize this filed either.

Any suggestions would be appreciated.

0
Nancy Villa
Asked:
Nancy Villa
  • 9
  • 4
  • 4
1 Solution
 
mlmccCommented:
Try using variables and formulas

In the report header
Formula name - declVars
Formula
shared numbervar intCountComplete:= 0;

In the group footer
Formula name - incCountComplete
if @complete >.75 then
  intCountComplete : = intCountComplete + 1;


In the report summary
Formula Name dispCountComplete
intCountComplete;

mlmcc
0
 
Nancy VillaDirector of ITAuthor Commented:
For the second formula
Formula name - incCountComplete
if @complete >.75 then
  intCountComplete : = intCountComplete + 1;

I get an error message A number, currency amount, boolean, date, datetime, or string is expected here.

Nancy
0
 
mlmccCommented:
Sorry should be
shared numbervar intCountComplete;
if {@complete} >.75 then
  intCountComplete : = intCountComplete + 1;

mlmcc
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Nancy VillaDirector of ITAuthor Commented:
I tried that, and still get the same message. My{@complete} is
Sum ({@Total Attended}, {Agency_Participant.Participant_ID})/ Count ({Agency_Attendance.Session_Number}, {Agency_Participant.Participant_ID})

does this help.
0
 
Nancy VillaDirector of ITAuthor Commented:
When I get the error message the first intCountComplete is highlighted.

I hope this will help

Nancy
0
 
mlmccCommented:
WHere are you putting the formula?

mlmcc
0
 
Nancy VillaDirector of ITAuthor Commented:
The declVars in the report header

the  incCountComplete in the Group footer

the dispCountComplete in the report footer.

I get the error message as soon as I tried to save the incCountComplete formula.  


0
 
mlmccCommented:
Try it like this

if {@complete} > 0.75 then
  intCountComplete : = intCountComplete + 1;

mlmcc
0
 
Nancy VillaDirector of ITAuthor Commented:
I still get the same message,
0
 
Nancy VillaDirector of ITAuthor Commented:
I am using Crystal 10.  Would that make a difference?
0
 
GJParkerCommented:
The formula should read

WhilePrintingRecords;
shared numbervar intCountComplete;

if {@complete} >.75 then
  intCountComplete := intCountComplete + 1;

Gary

0
 
Nancy VillaDirector of ITAuthor Commented:
I replace the formulas and I still receive the message when I go to check the second formula

It reads: A number, currency amount, boolean amount, date, time, datetime, or string is expected here.

the first intCountComplete is highlighted.

Thanks

Nancy
0
 
GJParkerCommented:
can you print all 3 formulas here then I can check the syntax

Gary
0
 
Nancy VillaDirector of ITAuthor Commented:
dclvars
WhilePrintingRecords;
shared numbervar intCountComplete;

incCountComplete
if {@Complete} > .75 = 1 then
  intCountComplete := intCountComplete + 1;

dspCountComplete
 intCountComplete;

Nancy
0
 
GJParkerCommented:
Try These

dclvars
WhilePrintingRecords;
shared numbervar intCountComplete:=0;

incCountComplete
WhilePrintingRecords;
shared numbervar intCountComplete;
if {@Complete} > .75 = 1 then
  intCountComplete := intCountComplete + 1;

dspCountComplete
WhilePrintingRecords;
shared numbervar intCountComplete;

Gary
0
 
Nancy VillaDirector of ITAuthor Commented:
That was it, it worked.  Thank you, Thank you, Thank you,
0
 
GJParkerCommented:
Glad to help
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 9
  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now