I am tearing my hair out on what seems to be a simple thing. Having read everything I can find I reach out to the community.

I have a summary field ("sum of students") that counts the number of students assigned to each teacher. Each student is a separate record so it's a simple Count summary. When I sort by TeacherName I get the result of "John Doe has Y students" where Y=the count of records, or students, that each teacher has. No problem. My report, sorted by TeacherName, successfully shows me all of the teachers (each in a sub summary part) their student names and a total number of students.

Now I want to add a simple calculation to that sub summary line of text.

"John Doe has Y students" Followed by (Y x .75)

which should read:

"John Doe has 2 students (1.5)"

I tried the following

GetSummary ( sum of students ; TeacherName ) * .75

Observations:

I know the the summary field calculates.

The break field is the same as the sub summary sort field.

the Sort is correct and includes sub sorts to alphabetize by student names.

All of the fields are in the same table.

The result invariably comes out as zero as if the GetSummary calculation is getting a zero value from the summary field "sum of students".... despite a numeric value showing successfully in the same layout.

When I remove the calculation (* .75) and just put:

GetSummary ( sum of students ; TeacherName )

I get a blank result.

Any ideas oh wise ones?

Would an exact copy/paste of your expression exactly match what you've posted here, or might we see that TeacherName comes from a related table?

A limitation of GetSummary that does not apply to sub summary parts is that the calculation field, the summary field and the break field must all be from the same table and referenced via the same table occurrence name.

If that's the case, you may need to add a calculation field that copies TeacherName into the table where you are counting records, then you refer to it as your break field in the getsummary function and sort on this new calculation field instead of the related field.