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.

Nancy VillaDirector of ITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nancy VillaDirector of ITAuthor Commented:
That was it, it worked.  Thank you, Thank you, Thank you,
0
GJParkerCommented:
Glad to help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.