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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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