Jump 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.

count of value list choices

Featured Replies

  • Newbies

I am trying to get a total figure for each of 4 choices of a value list. I can't sem to get it to work. For example my value list is called types of concerns with the four choices of 1) academic 2) behavior 3)attention 4) emotional. I have 355 record with each record having one of those four choices in the record. I want to see have many I have of each type. I know it can't be as hard as I am making it.

academic = PatternCount ( checkbox ; "academic" ), etc. Then summary fields for each:

sumacademic = ( total of academic ), etc.

If this is just for preview or print, add just one summary field:

Count of Records (Summary) = Count of RecordID

Then use a Sub-Summary by Type of Concern part (instead of a Body part) in a list view. Insert the Type of Concern field and Count of Records field on this part, sort it by Type of Concern, and print or view it in Preview Mode to see the results.

The advantage of this method is you don't have to have new fields for each value list choice. There is also a method of creating a file for the value list choices, but that's probably more than you need for such a short value list.

  • Author
  • Newbies

Thanks for your help

Create an account or sign in to comment

Important Information

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

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.