Boolean Count 1

[colkas]

I have a YES NO field that I need to put a count on for only Yes. Could someone please tell me how to do this.
Thanks

 

[Reebo99]

Create a formula :

If {table.field} = Yes then 1 else 0

(replace item in bold with your boolean field)
Place this in the detail, right click, insert, summary, SUM


Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[colkas]

but how does this count, I ut the formula in and I get 0 sould be 4 trues

 

[colkas]

Sorry Reebo got it in the end must learn to read thanks for your help works well