summary field for average

[mleiser]

I have a table of courses for each student and their grades. I'm trying to get averages for the different courses. So I created a summary filed for the number of grades per course (sort by course) and summary for total of all grades for course. Then I have a summary part that has the course name (summary break on course name) and I created a calculation field for the total of grades over the number of grades that their are rounded to two decimal places. The summary fields look good (for example, one course may have 10 students taking it, total of grades may be 890. Those are the summary fields. Then I'm trying to divide those numbers to come up with the average - 89. The average part is not working. I get the same number in each course??? Hope this question makes sense to somebody out there! Thanks

Mike

[comment]

You need to use the GetSummary() function in order to get sub-summary values in a calculation. In this case, there's a simpler solution: instead of two summary fields and a calculation field, use one summary field defined as Average of [Grade].

[mleiser]

You need to use the GetSummary() function in order to get sub-summary values in a calculation. In this case, there's a simpler solution: instead of two summary fields and a calculation field, use one summary field defined as Average of [Grade].

If I use average of grade - say there are ten records with that course name and only 8 have an actual grade, will it divide by 8 or 10?

[comment]

That's something you could easily find out yourself.

[mleiser]

That's something you could easily find out yourself.

Thanks a lot! It worked beautifully.