<p>I'm trying to create a survey report which needs to take an average of a group of average scores. The problem is BIRT is calculating the overall average using all of the underlying data instead of taking the average of the 3 already computed averages, is there any way to avoid this?</p>
<p> </p>
<p>As an example, a group of questions could be:</p>
<p> </p>
<p>Scale 1-100</p>
<p> </p>
<p>How did you like these things about your school:</p>
<p> Teacher - 81.9</p>
<p> Library - 92.9</p>
<p> Playground - 99.3</p>
<p> </p>
<p>I want the overall score to be 91.37</p>
<p>(81.9 + 92.9 + 99.3) / 3</p>
<p> </p>
<p>But I'm getting a slightly lower number like 91.25 because BIRT isn't taking the average of the 3 averaged numbers but the average of all the scores in the group.</p>
<p> </p>
<p>I hope I have explained this well enough.</p>
<p> </p>
<p> </p>
<p>Kindest regards,</p>
<p>Shayne</p>
<p> </p>
