Average Function in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do I get the average function to ignore columns that have 0.00 as the
amount. Or is there a way to hide the zeroes like you do in excel.
 
Stuart said:
how do I get the average function to ignore columns that have 0.00 as the
amount. Or is there a way to hide the zeroes like you do in excel.
Click to expand...


The Aggregate functions ignore null values so you can test
for 0 and use Null instead:
=Avg(IIf(field <> 0, field, Null))
 
Back
Top