Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Find count of unique values of a particular field

Featured Replies

I would like to be able to find a count of the unique values of a particular field in a found set, e.g. find how many different last names there are in a list of people.

I've dabled with calculations triggered by scripts, summary fields based on the field in question, but the only way I've gotten it to (sort of) work is to create a value list from the field, then do

ValueCount ( ValueListItems ( "DatabaseName" ; "FieldValueList" ) )

however this seems to work only for the entire database, not just the found set.

This topic and this one cover this a bit, but its not clear if they've gotten it to work, I don't completely understand their solution, and they seem to be doing something more complicated.

This seems like it should be a basic function for a report- to summarize unique values, and I can get a list, but I just want a simple count at the click of a button.

See comment's description from the second thread:

http://fmforums.com/forum/showpost.php?post/197350/

Because it involves the getsummary() function, you do have to sort the found set to get the result.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.