Getting an Average to display on a report

[Bandenjamin]

I have a report where there are T/F fields. In the Group footer these fields are totaled and a percentage is calculated(ie if all 11 are checked for group it will report 100%). The report will consist of about 25 of these records. I am trying to add an "average" percent at the bottom of the report in the Report Footer. Any suggestions? Any help I can get is Hugely appreciated.

Thanks,

Dan

 

[lameid]

I guess it depends on what 'T/F' fields are...

At any rate, if you have the percentages as a calculated filed in the query and not the report, you could simply use the AVG function on the field.

 

[Bandenjamin]

I tried that but it didn't work. I did find that I could do a Running sum over the group and change the format to a percentage and got the desired results.

Thanks.