Averaging an Average... 1

[Timmkatt]

CR 10
I am creating a report from survey data we receive for our drivers. The report displays the data as follows:

Driver Name: ALLEN

Question: Average of response:
D1 3.80

D2 3.60

D3 4.00

The Response column is an average of all the responses received for each question. What I need to do is get a total average for the average of responses for a total score. In this example the Drivers total score is 3.8. But I cannot seem to find a way to average this column for a total score in the report design. Is there an easy way to do this? Thanks.

 

[Turkbear]

Hi,
Is the 'Average of response:' col a computed field within
the report or is it in the datasource as an average?

If computed, then you just need to create another summary ( as a Grand Total ) on the response field.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

You could use these formulas:

//{@reset} to be placed in the driver group header:
whileprintingrecords;
numbervar ave := 0;
numbervar cnt := 0;

//{@accum} to be placed in the question group header or footer:
whileprintingrecords;
numbervar ave := ave + average({table.response},{table.question});
numbervar cnt := cnt + 1;

//{@display} to be placed in the driver group footer:
whileprintingrecords;
numbervar ave;
numbervar cnt;
if cnt > 0 then
ave/cnt

-LB