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.

Summary based on total records, not just found?

Featured Replies

  • Newbies

Is there a way to have a summary field that bases its value off of *all* records in a table, not just the found set of records? Or some other way to accomplish this task, as part of a field definition?

Specifically, I'm wanting to create a "count of" that counts all the records for which a certain other field has a particular value (well, any value really), but have it based on all the records in the whole table, not just the found set. Because I will be viewing it through a portal inside a related table, the found set only consists of the related records, but I want it to calculate it based on all records.

It used to work back in FMP 4 or 5, however it no longer worked as of v6; perhaps FMP used to base summary fields off of all records in a database, or maybe it used to not automatically make the found set just the related records when viewing through a portal. Either way, I haven't been able to figure out either a summary or calculation to do this. Any suggestions would be much appreciated!

The Cartesian join, signified by the X in the relationship definition, allows one table to be related to all records in another table or itself, similar to the way a constant calculation of 1 was used for previous versions. So, create a relationship using this join and then use Count( rel::field ).

There has been no change in FM4 to FM6 for summary fields. Summary fields have always been based on the found set. Your terminology is unclear. You say you want a count of all records, and then you say you do NOT want a count of all records. You appear to want a count of related records where the relationship is a self-match on a particular field.

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.