I want to determine the AVG of a field without including any "0" fields. I can not leave these fields blank, because in another area I use the AVG with the "0" fields. My formula is =AVG([fieldA]>0) however, the AVG it returns can not be correct because all of the non "0" values are positive, and the value returned is -0.4. Any help would be greatly appreciated. Thanks.