Calculate an overall score from 10 percentage scores 1

[debq]

Hello tek folks,

I have a report that includes 10 questions each question is scored as follows:

=Count([Question]) to give the [Total Responses]
=SUM(IIf([Question]="yes,1,0)) to give the [Total correct]
=[Total Responses]/[Total correct] to give the percent

I need an overall score for the 10 questions. A percent aggregate score.

How can I average all of the percents to get an overall average percentage score???

 

[genomon]

How about the average function Avg()?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[Remou]

This seems wrong to me:

=[Total Responses]/[Total correct]

Surely you want the percentage of total responses that were correct? That would be:

[Total correct]/[Total Responses] * 100

This would mean that a calculation of percentage in the report footer should give the answer you require.

[tt]
Qs TR TC %
Q1 10 5 50
Q2 10 7 70
Q3 10 6 60
Tot 30 18 60[/tt]

 

[debq]

Thank you for this response.I was able to set up the totals as you suggested and it worked.Thanks again.