Counting Records based of Bolean value

[CappsRLO]

I have a list of records which contain a Bolean field (True,False). In the SQL DB the value shows as 1 or 0.

I am unable to find a formula to give me a number for records that are True and False.
Example: Records that are True = 100

 

[lbass]

Create two separate formulas to place in the detail section:

//{@true}:
if {table.field} = true then 1

//{@false}:
if {table.field} = false then 1

Right click on each of these and insert a summary (a sum, NOT a count).

-LB