Averaging the total score for a multi-question evaluation...
Posted on 2006-03-30
I have a evaluation form that collects a score (1 - 10) and some comments.
Several people will evaluate one person, in turn submitting a form for each evaluation.
I need to average the scores for each question from all the Evaluators and
display the total average and each comment from all the evaluators in one result record
for each question.
Eval1 Eval2 Eval3 Eval4
5 4 7 6
Comment1 Comment2 Comment3 Comment4