customlist fuction

[kiwioz]

Hi all

I know that the customlist function is a really powerful function, but I need help

I have a Table with 62 records and a field called "Rego" that on 6 records are set to 1 the others are set to 0

How can I use the customlist function to tell me how may records have 1

So total records 62 "ergo" = 6

Please help

Craig

[comment]

Why not simply use a summary field defined as Total of [Rego]?

Note that this will summarize only records in the current found set (same as using a custom function would).

[kiwioz]

Why not simply use a summary field defined as Total of [Rego]?

Note that this will summarize only records in the current found set (same as using a custom function would).

Thanks for you fast replay.

How could I use this to set a variable ?

[comment]

In what context and for what purpose?

[kiwioz]

In what context and for what purpose?

I want to use it to show a Bar graph

Entered 6 of 62

Thanks

[comment]

Do you mean like this?

SummaryChart.zip

[kiwioz]

Do you mean like this?

WOW thanks for your help with this

Your example is using two bars, one to show total records the other to show sTotalValid

If I was to use a bar not a hormonal bar, is there a way of showing the vertical(Y)Axis to indicate the total records ?

Then can this be done with only one bar?

[comment]

I don't think that's possible using the Filemaker chart tool. Perhaps a pie chart would be more suitable.