null or 0 values in a percentage calculation in access

T

Tracy s

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.
 
D

Duane Hookom

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)
 
Top