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.

Sort calculation of total per type – result won’t show for all types

hag
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

I am trying to have a list that would show the sum of records sorted by type.

The DB has two tables "list" and "list line". "list line" is self joined to "List_line_Type" based on the fk ListID and Type. The sum field for Type is a calculation field: Case (Type = 1 ; List_line_Type::Total) and Case (Type = 2; List_line_Type::Total).

Next I want the sum as sorted by type to show in the List table. The fields are defined as calculation filed = List_line_Type::Tot_type1 and ...Type 2.

While the right results appears in the List_line table, they will not show correctly on the List table. It's as if FMP only evaluates the first related record and hence shows the calculation of the Type of that first record ignoring the rest.

What am I doing wrong?

List.fp7.zip

There are several ways to do this - here's one:

List.fp7.zip

  • Author
  • Newbies

Thanks! it works perfectly

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.