Averaging Calculated Fields?

[Benjamin Bolduc]

Hi everyone,
I have a report that has many calculated fields on it. It is grouped by "Pack#" and has a footer that I would like to put the averages of these fields in.
Heres an example of one of the fields:

(In Detail Section, the field 'TotalTime')
=[Producing_time]-[Total_Change_time]

And I would like to put in the footer
=Avg([TotalTime])

But it doesnt work and asks me for parameter values.

 

[David R]

You'll have to repeat the calculation in the footer, I believe, according to previous postings.

David R

 

[Benjamin Bolduc]

Well thats where the problem is, I repeated the calculations in the footer, but only the fields that were averaging Bound feilds worked properly. Those that were averaging calculated feilds gave me Enter Parameter Value boxes and didnt work right. I must be doing somthing wrong, and there must be someone out there that's smart enough to help me

Please help!

 

[Happy YN]

I had a similar thing recently. I decided to have an invisible text box that did a running sum and another with the controlsource set to =1 and also a running sum. This gave me two figures and when I divided the running sum by the number of records thats your average
HTH