null or 0 values in a percentage calculation in access

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

Guest

I am trying to get a percentage from a number of columns, but sometimes the
fileds are blank. I need to make the calculations ignore the 0 so that I get
a true percentage figure.
 
If the "fields are blank" then they aren't 0 so they will average as
expected. If you want to ignore 0 you may need to use an expression like:
Avg(IIf([YourField] <>0,[YourField],Null)
 

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

Access Group by precinct, calculate percentage of older voters 0
Blank or Null in a Cross Tab Query in Access 2003 2
Percentage calculations and 0 values - Help 2
Force Percentage Form 1
Calculate percentage 2
Calculating Percentages Using a Query 3
Access Test if value is less than percent 0
Excel How to calculate percentage for time 1

Back
Top