count of value list items

[mrc]

Hi

I have a db setup with several value lists. When doing a report I would like to be able to show a count of the value lists choices; value list has faculty, staff, secretarial. Want to be able to show how many faculty, how many staff, how many secretarial. Any ideas?

Thanks, mrc

[LuckyMe]

There may be other way to answer your quesiton, but this is mine:

ValueList = ValueListItems( "Your DB", "List1")

where: Your DB is the DB that the valuelist is defined

List1: value list name

Both need to be inside ""

Count = PatternCount(ValueList, "

[bobsmith]

This can be done with calculated field if all value list items are the same number of words. For example if all items are one word, such as last name" use this:

WordCount(ValueListItems("Your DB.fp5","Your Value List"))

If they are two you would just have to say:WordCount(ValueListItems("test.fp5","New Value List"))/2.

If they are all different it would be a little more complicated.

[bobsmith]

I like Luckys better, I didn't see it until I posted mine.

[mrc]

Thanks for the suggestions, I have put in

ValueListItems( "FSHN Support", "type"PatternCount ( "faculty" , +1 ) )

but get the error "an operator is expected here - highlighting the nt( after Count

[Thom]

If I understand your scenario, you have a field called 'type'. The values in 'type' come from a value list with 3 values. Some records have "faculty", some have "staff", and some have "secretarial". For each type you want to know how many records there are. Correct?

Create a Summary field called 'typeCount' with a count of 'type'. Create a new layout that's a columnar list/report. Select Report with grouped data. Under Specify Fields, choose 'type' and 'typeCount'. Under Organize Records by Category choose 'type'. Leave Sort Records with 'type' selected.

Sort the found set by 'type', then view the new layout in Preview mode.

There are other ways to do this that work in Browse mode, but the fields become very slow to display when you have many records.

[mrc]

Thanks - that worked!