Jump to content
Sign in to follow this  
tomp

Number of values in a found set

Recommended Posts

Is there an elegant way to count the number of different values for a field in a found set?

I can think of using a calculation field that has the field value if in the found set, empty if not. Then defining a value list for that calc field and counting the items with a values function. But that seems rather cumbersome.

TIA

Share this post


Link to post
Share on other sites

I can only see how to use sub-summaries to tell me how many records of each value I have in a found set. What I need is how many distinct values of the field there are in the found set.

For example, if I had a database of restaurant tickets with menu items ordered,how could I determine how many different tickets had a particular item on them?

tkt 1 item 1

tkt 1 item 2

tkt 2 item 2

tkt 2 item 2

tkt 3 item 1

If I did a find on 'item 2', there would be three records found. The number of values for 'ticket' in the found set is '2'. '2' is the number I need to get.

I don't see how sub-summaries will help me with that.

Am I missing something?

Share this post


Link to post
Share on other sites

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/197861/

Share this post


Link to post
Share on other sites

I downloaded the 'test' database from the previous thread and mimiced it.

It gives me what I need.

Thanks!

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.