A QAD method would be a calc field that returns 1 if the other field = "Yes". Then you could just use SUM to add the calc field values - maybe a self join on a constant that = 1.
"Getting information off the Internet is like taking a drink from a fire hydrant." ~ Mitchell Kapor
How about a Count where field is Yes via SQL.
Or a relationship based in a global Yes field with a Count of related records.
If you're working with a found set of records, an option added to FileMaker 13 is the "List Of" summary field.
That would give you a result that looked like:
You could then use FilterValues on that list to leave you with just the 'Yes' values, and then apply ValueCount to give you the result.
Before doing that I'd ask: do you know how to do a standard report using a sub summary, sorted by the field in question, with the a standard summary field defined using the Count feature?
Very good point, Bruce.
thanks for all the good responses. Seems like the idea I like best is the calc field that returns 1 if the other field is "Yes" then just sum the calc field.
I struggling a bit with FM in setting up things that I could have just programmed a language like C but I sure do like how fast I can get basic stuff done...
I have written quite a bit with Xojo and although it has some great power, it sure takes a lot more time to get things done....
I've got it all working and added similar fields for males and females. Works just like I wanted.