Sum of Yes-No return negative number

  • Thread starter Thread starter Carol Mc
  • Start date Start date
C

Carol Mc

I'm doing a simple report that sums the number of yes
reponses in a field. Works great except the answer is a
negative number. Any ideas what I am doing wrong?
 
You are not doing anything wrong. Yes is "-1" and no is "0". If you sum a
bunch of "-1"s then you will get a negative number.

Rick B
 
Carol,

Convert your count to positive with the absolute value function Abs():

=Abs(Sum([MyBooleanField]))

Hope that helps.
Sprinks
 
Back
Top