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.

getsummary() blank

No_access
in Calculation Engine (Define Fields)

Featured Replies

getsummary() not working
 
Ok, this should be simple..
I have a report
with several sub-summary parts.
one part is sub-summay by _AccountID.
on this part is 3 summary fields.
sumisinrange14
sumisinrnage13
sumisinrange12
 
I need to add these together.
so I added a calculation field
GetSummary (sumisinrange14 ;_AccountID)
 
this should show the sumisinrange14 field. but it is blank.
 
the sort order is
Accountnumber
_accountID
productgroupPeraccount2
 
so the sort is there but the getsummary feld is blank
 
  • Author

ok. I got it. after getting away from it for a while.  needed to add relationship and access that way.

Summary fields summarize the found set; relationships ignore found sets. Mixing the two methods can easily produce unexpected results. I see no reason why your original calculation should not work (meaning that the reason is not to be found in what you shared with us so far).

Create an account or sign in to comment

https://fmforums.com/topic/94091-getsummary-blank/
Go to topic listing

Important Information

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

I accept

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.