Needing Assistance with Count Calculations

[Paladin_Brewer]

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!

[Paladin_Brewer]

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, 2008 by Guest

[Inky Phil]

Try Sum instead of count

hth

Phil

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

Edited July 21, 2008 by Guest

[Paladin_Brewer]

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?

[Inky Phil]

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

[Paladin_Brewer]

That worked great, thanks much