Is that middle value really zero in your case or does your database show it as an empty field?
Missing values are not included in the computed mean by FileMaker, Values of zero should be included in the calculation as far as I know.
Wow, I guess you're right!
It's the value missing, not the value zero.
Thanks very much,