Jump to content
Sign in to follow this  

Looking to count value in multiple valuelists

Recommended Posts

I am looking the count the content of value list fields. There are 8 value list fields on the table that I would like to know the content count for.

The value list field contains one of 10 choices and there are 8 fields that a user can populate.

What I would like to find and list is the value and how many times it comes up in those 8 fields.

So I am looking for it to show on a report like this.

ValueOne = 30

ValueTwo = 20

ValueThree =2 5


Thanks in advance for any help.

I am developing this in FM 10 Adv and my users are on FM 10.

Share this post

Link to post
Share on other sites

This isn't quite clear: why are there 8 fields - do they all use the same valuelist, and if so, are duplicate choices allowed? In short, a less abstract description would be helpful.

Share this post

Link to post
Share on other sites


There are 8 fields to list multiple problems that are in the same value list and no they are all to be different.


Share this post

Link to post
Share on other sites

no they are all to be different.

I am not sure how you enforce that, but that's not the point. The issue here is bad data structure, with 8 fields doing the job of what would ideally be 8 (or any number of) related records (or at least a single field with return-separated values, e.g. a checkbox).

You could still produce a kind of the report you want, provided you have a table of problem values (not just a value list), and a calculation field in the :P table (where the 8 fields are) =

List ( Problem1 ; Problem2 ; ... ; Problem8 )

If you define a relationship between the 2 tables using the calculation field, then each Problem record can count its related records. However, it's merely an ugly patch on the real flaw, and it has the drawback of ignoring any found set in the :P table - it will always summarize ALL records in that table.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.