Omit zeros in calculation

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

Guest

Is there a way/formula to omit records with a zero value when calculating an
average on a report?
 
In the Report Footer section, add a text box.
Set its Control Source property to something like this:
=Avg( IIf([Amount] = 0, Null, [Amount]) )
Substitute your own field name for Amount.

This solution uses the fact that Access ignores nulls when calculating
averages.
 

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

Calculating Averages 10
How to omit blank cells when calculating weighted averages 20
Hiding a #Num! occurrence in a report output 4
Omit empty cells? 0
Range Arguments 1
zero value cells/blank cells causing error in AVERAGE? 5
Averaging 2
Omitting zeroes when looking for minimum values 2

Back
Top