### Title

I get the wrong average result

### Post

Hi,

I am an ESL teacher and I use FM to present the students with their term tests results but I can't get the final average result that I am supposed to.

I have number fields with the test results. These are in the body of the layout. Each test result has a skill field attached such as writing, reading, grammar... etc.

Then I have a sub-summary part for each skill with a summary field to get the average test results of each skill.

Finally I have another sub-summary part for each student. I want to get the skills average results of each student as distinct from the total test average result but I can't. I can only get the average test result and I can't get the average skill result.

Some students have pointed out to me that those to results are different. And since the average skill result has a higher value on their calculators they want me to use that calculation.

I have also tried with the GETSUMMARY fuction but I can't get to the result you get when do calculate the average of the skill results.

What am I doing wrong? Can you point me to the right direction?

Thanks!

Juan

Is it possible to post a sample file with some sample data. In all likelihood, I think you may have complicated this more then needed, and you may have the calculations on the wrong table/table occurrence.