>FYI -- The "Print When" clause is only used to determine whether or not to print the field. Calculations do NOT honor this setting and will calculate, regardless of the "Print When" setting.
>

I'm not so sure about that Cathy. I've used the Sum calculation in reports to only sum the results printed, even though there are additional values not printed. I can't imagine it works any differently for avg.