I could swear this one would be easy...(for me)!

I have this 0/1 field in every record...I just want to know how many cases are positive (1).

Thought -Count (field=1)- would do it, but it does not...

Stuck again!!!

Researched but didn't find any answers... appreciate any hints...

Thanks

I suggest that you look up a function in Help before you try to use it.

Sum ( field ) produces the value of field. You've basically asked Filemaker to compute Sum ( 1 ) and the sum of 1 is 1.

Sum can be used in different contexts.

Sum ( RelatedTable::Field )

will return the sum of Field over the set of related records. Bu that means defining your calculation field in a different table than "RelatedTable".

A "Total Of" summary field, on the other hand can return the total of the field it "totals" over the current found set if used in the right context.