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.

Sub-Summaries Calculations

Tony Leslie
in Calculation Engine (Define Fields)

Featured Replies

  • Newbies

I'm having trouble making calculations within a sub-summary panel. Example: a sub-summary panel lists total sales volume per salesman and the quantity of units sold, using two summary fields. I want the average sale price per salesman, so I create a calculation field that divides the summary field for dollar volume by the summary field for units sold. This works fine when I place it in the grand summary panel, but in the sub-summary panel it shows the grand total result. Same thing happens for any other type of calculation. Any suggestions would be greatly appreciated.

As a rule, you need to use the GetSummary() function when referring to summary fields in calculations involving sub-summaries.

In this case, you have an easier option: define a summary field as average of Price, weighted by Quantity.

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.