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.

counting field

juanito2004
in Calculation Engine (Define Fields)

Featured Replies

Let's say I have 10 number fields in each record. I would like to create a field that counts how many times a value over 400 (for example) has been entered in those 10 number fields.

So if 2 of them are over 400 and the other 8 under, I would get a value of 2 in this new field.

Any help is much appreciated. I am still a beginner with this software.

(field1 > 400) + (field2 > 400) + (field3 > 400) + ... + (field10 > 400)

Replace > with >= if you meant 400 or greater. Each of the tests will be treated as a boolean and return either 1 or 0 (true or false), giving you a total of the number of fields for which the statement is true.

Create an account or sign in to comment

https://fmforums.com/topic/26894-counting-field/
Go to topic listing

Important Information

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

I accept

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.