Thanks, Aaron.
Looking at that sample made me realize how badly I described my problem.
If all I had to do was count classes and divide into the total number
of students, I'd have no problem.
Let me be more clear.
The classes all have different numbers of meeting times. What the
client wants is the average number of students per meeting time. So
each record line looks something like this:
Meetings Students Avg.
Art101 10 71 7.1
Meetings is the number of times the classes meet. Students is the
number of times a student was present at a class meeting. The last
column then gives the average number of students per class meeting.
This is subtotaled by class location, then by grade level, and then by
region. This is done with sub-summary parts, of course, and the totals
for number of classes and the totals for the number of student-
attendances work fine.
What I need is to get an average summary or calculation field that
works at each sub-summary level that gives an average of the total
student-attendances per total number of classes. I have not yet found
the magic calculation to display that.
I have tried:
1. Putting a Summary "Average" field in the sub-summary parts.
2. Putting a calculation that calculated from the sub-summary total
fields in each SS part.
Neither works.
Any suggestions?
On Oct 27, 2009, at 10:54 PM, Aaron Gutleben wrote:
> Hi Jonathan...
>
> This link is to an example file that Kevin Frank put together. It
> should
> help you with your challenge.
>
>
http://www.kevinfrank.com/download/classroom-averages.zip>
> Aaron
>
>
> On 10/27/09 7:32 PM, "Jonathan Fletcher" <
[hidden email]>
> wrote:
>
>> I have a solution that manages accounts and classes.
>>
>> There is an enrollment report that lists classes and student counts.
>> On each body line there is a calculated value that averages students
>> per class.
>>
>> When I try to include an average in the sub-summary parts the numbers
>> aren't right. I have tried summary average fields. I have tried
>> calculated fields that divide the summary total fields. Nothing I've
>> tried calculates it correctly.
>>
>> Does anyone have a trick for having averages in sub-summary (and
>> grand
>> summary) parts?
>>
>> TIA!
>>
>>
>> --
>> Jonathan Fletcher
>> FileMaker 9 & 10 Certified Developer
>> ****NEW Ph no: 502-509-7137****
>>
>> Project Foreman
>> NewMedia Construction Co.
>>
[hidden email]
>>
>> Instigator
>> The BB&J Network
>> The "Go-To Guys" for
>> FileMaker Development in Louisville
>> www.thebbandj.net
>>
>> FileMaker Louisville Blog:
>>
http://filemakerlouisville.posterous.com>>
>>
>>
>> _______________________________________________
>> FMPexperts mailing list
>>
[hidden email]
>>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au>>
>
>
> _______________________________________________
> FMPexperts mailing list
>
[hidden email]
>
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au--
Jonathan Fletcher
FileMaker 9 & 10 Certified Developer
****NEW Ph no: 502-509-7137****
Project Foreman
NewMedia Construction Co.
[hidden email]
Instigator
The BB&J Network
The "Go-To Guys" for
FileMaker Development in Louisville
www.thebbandj.net
FileMaker Louisville Blog:
http://filemakerlouisville.posterous.com_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
