>You could try to encorporate the ISNULL function in your averaging...
>What I'm thinking is either:
>
>a) SET FILTER TO NOT ISNULL(cFieldname) before you run the report
>or
>b) In the print when clause of the field containing the variable calculating the average.
>Put NOT ISNULL(cFieldExpression)...
>
>I have many problems with NULL fields when I connect to oracle...But haven't dealt directly with this particular problem.
Tim,
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.
Cathy