counting boolean 1

[colkas]

I want to be able to count on a list of true or false answers but only the true's. I ahve tried various formulae but either get all counted or none at all. Any ideas please.

 

[bdreed35]

Try creating a formula to evaluate your field at the detail level.
*************************************
@Evaluate

if {table.field} then //if True
1
else //if False
0
*************************************
Place the formula in you detail section and then suppress it.
Insert a Summary based upon this field at whatever level you require. Make sure that the summary type is SUM.

~Brian

 

[colkas]

Thanks but now when I right click on the field in the detailed section and select summary there is no sum option.

The formula now shows just the true but all 8 lines there are 3 true ones, so I expect to see 3