Avg in Report Footer

[jwood29]

How do I go about adding an average field in report footer that will give me the average of all the scores.

Thanks.

jwood29

 

[boblarson]

Make sure that the control name is not the same as the field name up in the details section and then put a text box in the footer with

=Avg([YourFieldNameHere])

You might need the NZ function if you want to count null fields in.

=Avg(Nz([YourFieldNameHere],0))

 

[jwood29]

boblarsen to the rescue again. Thanks, that's what I needed. Got it calculating nicely now. you still 'da man'.
Good Day bud.

 

[jwood29]

How would I not include 0 "zeros" in the calculation of average?

Thanks.

 

[georgedwilkinson]

Use Bob's second example:

=Avg(Nz([YourFieldNameHere],0))