First I would like to point out that I am new to Filemaker, and pretty new to Databases period, so take it easy on me. But I have a client that uses Filemaker and wants Database changes, so I have to figure it out.

What I need to do is have a record that has several totals. These totals need to read fields to see if they say things like "Yes" or "No", and I need the totals of Yes and No. There are also fields that are dropdowns with 4 or so choices, and I need total counts of each choice for all records.

So my question is, how do I do this? I tried Count( Child_Active ) = "No" but that wasn't even close I guess.

Any help would be greatly appreciated!

Anyone at all? I could really use some help with this What I have now done is:

Made a calculation field that does

=If(Child_Active="Yes",1,0)

Then I made a summary field corresponding with the above field that does a count.

But it seems to just be totaling the number of fields, not how many say Yes

Edited July 21, 200817 yr by Guest

Try Sum instead of count

hth

Phil

ps You will find the syntax for the Sum function in your help files

Edited July 21, 200817 yr by Guest

I got this working with an If Statement:

If(Child_Active ="Yes" ,1 ,0)

And then a summary field showing the total.

My question is, for example, there are times when I have a dropdown with 4 choices, and an option for the user to "edit" and add in their own. So, how would I do an "Other" count, IE, counts everything besides those 4 choices in the dropdown?

Try the Case function which will allow you to have as many conditions and results as you might need along with a default result that might be used for your 'other' entries

Phil

That worked great, thanks much