Total of

[capimaz]

I'm tryin to do a report that give the total of persons that use cars. For example:

name use a car?
peter YES
bill YES
arnold NO
ruben YES

in the reporte footer I'm using this in a text box

=count([car]) and the result is 4, not 3

any idea about this??

 

[seaport]

if "Use a car" is a boolean field, the data in this field is -1 when it displays "yes" and 0 when it displays "no". Therefore, the source of the textbox is

(-1)*sum([use a car])

Seaport