G
Guest
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.
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.