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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Function 4
How do I get average days to fill? 2
average acts different in rows and columns? 6
Average Formula Help 2
Footer Average 2
Stuck on creating averages in a text box 5
Averages with conditions.... 1
I am trying to use the IF and SUMIF function on Excel 8

Back
Top