M
Moe
In a report I have a calculated field as "=Nz([Total],0)/Hrs" which works
fine. In the report footer I tried to get the average of the values in this
column so I used "=Avg(Nz([Total],0)/Hrs) but when I run it it asks me for
the value of "Hrs". Neither "hrs" nor "total" are calculated fields and no
error is generated either. The output for the average is just blank. I tried
=Avg(Nz([Total],0)/(Nz(Hrs,))) which did not work either. What am I missing?
fine. In the report footer I tried to get the average of the values in this
column so I used "=Avg(Nz([Total],0)/Hrs) but when I run it it asks me for
the value of "Hrs". Neither "hrs" nor "total" are calculated fields and no
error is generated either. The output for the average is just blank. I tried
=Avg(Nz([Total],0)/(Nz(Hrs,))) which did not work either. What am I missing?