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 field for related table

nscheffey
in Calculation Engine (Define Fields)

Featured Replies

Hi all-

I have what seems to be a straightforward problem, but I can't seem to figure it out. I have a Sales Report layout which shows records from the table LineItem, sorted by Order number. Trailing subsummaries for each Order group show totals of cost and sales, and a Trailing Grand Summary shows totals for all of the Orders displayed. All of these summary fields are defined in the LineItem table and work fine.

Now I need to show at the end of the report a total of the Orders displayed. Although this seems easy I can't figure it out. A GetFoundCount returns the total LineItems displayed, as does a Count of the _kf_Order field. What type of field do I need to create to show the total Orders displayed?

Thanks in advance for any help,

Nate

See here:

http://www.fmforums.com/forum/showpost.php?post/135493/

  • Author

Perfect! Thanks much Comment. Probably not something I would have quickly come up with on my own, but makes sense now that I think about it.

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.