Count

Filemake 8 Pro Mac 10.4.9

I need to count the number of responses in a radio box selection

Filed "Status" contain four possible answers "Apples"; "Oranges";
"Banannas"; and "Grapes". Provided using a value list.

What I am looking for is a running count of "Apples" being selected
displayed in an edit field NoApples.

I have worked with Count, Value Count and Valuelistitem and I have not
been able to hit upon a solution.

I have been looking for something like NoApples = count( status : :
"apples"), but to no avail. Can some one point me in the right
direction.

Re: Count

From Help:

Format
Count(field{;field...})

Parameter
field - any related field, repeating field, or set of non-repeating
fields; or an expression that returns a field, repeating field, or set
of non-repeating fields.

The idea here is RELATED FIELD.

Create:

a Global Field gApples, populate it as "Apples"

a relationship in a new Table Occurrence of the table containing Status
to be named Apples: gApples = Status

a field using the UNSTORED calc Count ( Apples::Apples )

Matt

On 09/13/07 5:53 PM, Ron Lambert wrote:

> Filemake 8 Pro Mac 10.4.9
>
> I need to count the number of responses in a radio box selection
>
> Filed "Status" contain four possible answers "Apples"; "Oranges";
> "Banannas"; and "Grapes". Provided using a value list.
>
> What I am looking for is a running count of "Apples" being selected
> displayed in an edit field NoApples.
>
> I have worked with Count, Value Count and Valuelistitem and I have not
> been able to hit upon a solution.
>
> I have been looking for something like NoApples = count( status : :
> "apples"), but to no avail. Can some one point me in the right direction.
>

--
Free FileMaker Technique Demos: http://www.VirtualVermont.com/FMP

My Custom Functions:
http://www.briandunning.com/filemaker-custom-functions/resul ts.php?keyword=wills

Re: Count

Oops, sorry, that calc should be Count ( Apples::Status )

Matt

Free FileMaker Technique Demos: http://www.VirtualVermont.com/FMP

My Custom Functions:
http://www.briandunning.com/filemaker-custom-functions/resul ts.php?keyword=wills

On 09/13/07 6:26 PM, Matt Wills wrote:

> From Help:
>
> Format
> Count(field{;field...})
>
> Parameter
> field - any related field, repeating field, or set of non-repeating
> fields; or an expression that returns a field, repeating field, or set
> of non-repeating fields.
>
> The idea here is RELATED FIELD.
>
> Create:
>
> a Global Field gApples, populate it as "Apples"
>
> a relationship in a new Table Occurrence of the table containing Status
> to be named Apples: gApples = Status
>
> a field using the UNSTORED calc Count ( Apples::Apples )
>
> Matt
>
> On 09/13/07 5:53 PM, Ron Lambert wrote:
>
>> Filemake 8 Pro Mac 10.4.9
>>
>> I need to count the number of responses in a radio box selection
>>
>> Filed "Status" contain four possible answers "Apples"; "Oranges";
>> "Banannas"; and "Grapes". Provided using a value list.
>>
>> What I am looking for is a running count of "Apples" being selected
>> displayed in an edit field NoApples.
>>
>> I have worked with Count, Value Count and Valuelistitem and I have not
>> been able to hit upon a solution.
>>
>> I have been looking for something like NoApples = count( status : :
>> "apples"), but to no avail. Can some one point me in the right
>> direction.
>>
>

Re: Count

In article <2007091315530816807-railman@sasktelnet>,
Ron Lambert wrote:

> Filemake 8 Pro Mac 10.4.9
>
> I need to count the number of responses in a radio box selection
>
> Filed "Status" contain four possible answers "Apples"; "Oranges";
> "Banannas"; and "Grapes". Provided using a value list.
>
> What I am looking for is a running count of "Apples" being selected
> displayed in an edit field NoApples.
>
> I have worked with Count, Value Count and Valuelistitem and I have not
> been able to hit upon a solution.
>
> I have been looking for something like NoApples = count( status : :
> "apples"), but to no avail. Can some one point me in the right
> direction.

Calc fields:

Apples = if(Status = "Apples";"x";"")
Oranges = If(Status = "Oranges";"x";"")
and so on.

Then summary fields (if in the same table, or calc fields with aggregate
function if in a related table) to count each each:

SummaryCountApples = Count(Apples)
SummaryCountOranges = Count(Oranges)
etc.

A text field formatted as radio buttons is great for assuring consistent
data entry. It is not useful by itself for statistical tabulations. You
have to go a step or two farther along the lines I suggest.

--
For email, change to
Bill Collins

Re: Count

In article
,
Bill wrote:

> In article <2007091315530816807-railman@sasktelnet>,
> Ron Lambert wrote:
>
> > Filemake 8 Pro Mac 10.4.9
> >
> > I need to count the number of responses in a radio box selection
> >
> > Filed "Status" contain four possible answers "Apples"; "Oranges";
> > "Banannas"; and "Grapes". Provided using a value list.
> >
> > What I am looking for is a running count of "Apples" being selected
> > displayed in an edit field NoApples.
> >
> > I have worked with Count, Value Count and Valuelistitem and I have not
> > been able to hit upon a solution.
> >
> > I have been looking for something like NoApples = count( status : :
> > "apples"), but to no avail. Can some one point me in the right
> > direction.
>
> Calc fields:
>
> Apples = if(Status = "Apples";"x";"")
> Oranges = If(Status = "Oranges";"x";"")
> and so on.
>
> Then summary fields (if in the same table, or calc fields with aggregate
> function if in a related table) to count each each:
>
> SummaryCountApples = Count(Apples)
> SummaryCountOranges = Count(Oranges)
> etc.
>
> A text field formatted as radio buttons is great for assuring consistent
> data entry. It is not useful by itself for statistical tabulations. You
> have to go a step or two farther along the lines I suggest.

I forgot the obvious solution:

Define a summary field Count of Status.

Define a new layout as columnar list/report. Include a subsummary part
when sorted by Status. Put the summary field Count of Status in that
subsummary part. Also put the field Status in the subsummary part to
serve as a label for which status value is represented.

Now find the records of interest, sort by Status, and view in Preview
mode or print it out. You will see a number of rows. Each row will have
the Status field displaying the value of Status pertaining to that row,
and the summary field displaying the count of items with that value of
status.

Note that you do not need a Body part in the layout, all you need for
your purpose is a header to hold a title and column headings, and the
subsummary part sorted by Status, with the fields in the subsummary part.

You may also want a grand summary part with the summary field in it to
show the total of all items that have a value of status.

--
For email, change to
Bill Collins

Re: Count

In article
, Bill
wrote:

> In article <2007091315530816807-railman@sasktelnet>,
> Ron Lambert wrote:
>
> > Filemake 8 Pro Mac 10.4.9
> >
> > I need to count the number of responses in a radio box selection
> >
> > Filed "Status" contain four possible answers "Apples"; "Oranges";
> > "Banannas"; and "Grapes". Provided using a value list.
> >
> > What I am looking for is a running count of "Apples" being selected
> > displayed in an edit field NoApples.
> >
> > I have worked with Count, Value Count and Valuelistitem and I have not
> > been able to hit upon a solution.
> >
> > I have been looking for something like NoApples = count( status : :
> > "apples"), but to no avail. Can some one point me in the right
> > direction.
>
> Calc fields:
>
> Apples = if(Status = "Apples";"x";"")
> Oranges = If(Status = "Oranges";"x";"")
> and so on.
>
> Then summary fields (if in the same table, or calc fields with aggregate
> function if in a related table) to count each each:
>
> SummaryCountApples = Count(Apples)
> SummaryCountOranges = Count(Oranges)
> etc.
>
> A text field formatted as radio buttons is great for assuring consistent
> data entry. It is not useful by itself for statistical tabulations. You
> have to go a step or two farther along the lines I suggest.

Yep. You're often better to make you own radio buttons / checkboxes
using a separate field and value list for each option (using scripts
and invisible buttons to make them appear the same to the user), then
Count will work.

Maybe FileMaker 10 will include the CountIf function available in
Excel. :o)

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)