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

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).

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 ?

In what context and for what purpose?

In what context and for what purpose?

I want to use it to show a Bar graph

Entered 6 of 62

Thanks

Do you mean like this?

SummaryChart.zip

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?

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