Urgent! Problem getting the right "average" result

[Arty]

Hi everyone! I will appreciate so much any help with this problem.

I'm trying to get the average on a report as a GRAND TOTAL, I have calculated by the normal method, the average for the periods (1st and 2nd semester), but when I try to get the final average (the 2 semesters together) I don't get the value I need to get ((a + : / 2 --> for saying something). I want to know how I can get the big right average here.

Thanks to everybody.

Arty.

[Peter Fenner]

Hi Arty (Welcome to FM Forums)

You need to add a "Trailing Grand Summary" on your layout. Just place the same summary field in this part of the layout.

(a + :/2 would not give you a correct result anyway.

For example: You have 3 results for First Semester: 10, 20 and 36. The average is 22.

You have 2 results for Second Semester: 48, 24. The average is 36.

(36 + 22)/2 = 29 but the correct way: (10+20+36+48+24)/5 = 27.6

Pete

[LiveOak]

Also be advised that you can't take a Summary field (call it Total) and divide it by another Summary field (call it Count) and get a correct result. To divide two summary fields, you must use the GetSummary() function:

Average = GetSummary(Total, Total)/GetSummary(Count,Count)

This works in a trailing grand summary. For a subsummary part it would look like:

Average = GetSummary(Total, SubSumSortField)/GetSummary(Count,SubSumSortField)

-bd