asked on

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.

Mike McCracken

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

Nancy Villa

ASKER

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

Mike McCracken

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

mlmcc

Nancy Villa

ASKER

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.

Nancy Villa

ASKER

When I get the error message the first intCountComplete is highlighted.

I hope this will help

Nancy

Mike McCracken

WHere are you putting the formula?

mlmcc

Nancy Villa

ASKER

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.

Mike McCracken

Try it like this

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

mlmcc

Nancy Villa

ASKER

I still get the same message,

Nancy Villa

ASKER

I am using Crystal 10. Would that make a difference?

GJParker

The formula should read

WhilePrintingRecords;
shared numbervar intCountComplete;

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

Gary

Nancy Villa

ASKER

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

GJParker

can you print all 3 formulas here then I can check the syntax

Gary

Nancy Villa

ASKER

dclvars
WhilePrintingRecords;
shared numbervar intCountComplete;

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

dspCountComplete
intCountComplete;

Nancy

ASKER CERTIFIED SOLUTION

GJParker

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nancy Villa

ASKER

That was it, it worked. Thank you, Thank you, Thank you,

GJParker

Glad to help