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.

Summary of Multiple Related Fields

life036
in Calculation Engine (Define Fields)

Featured Replies

Hello Everyone,

I'd like to add together all the numbers in a field of only the related records. The thing is, I'd like to do this for multiple fields at once. I'm aware that you can do the sub-summary and sort by that field to get a count of related records, but I'd like to do that for more than one at a time. Here's a Picture of what I mean - See all the zeroes on the bottom? I'd like those to be the added up totals of what is in the portal:

fmp_film.jpg

Is this possible with FMP 6? I also have 8 if I need to use that instead...

Thanks for any info you could provide!

Chris

Edited by Guest

A calculation field with Sum( relationship::field ) should do it.

  • Author

Awesome, thanks!

Don't know why I couldn't get that to work before, but it works great now!

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.