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.

Issue with Calculated field that utilizes a summary field

NickFaraday4
in Calculation Engine (Define Fields)

Featured Replies

I'm having some issues with a calculated field....

I have a bunch of invoices with line items each line items has a number of boxes the items come in. I have a summary field that gives me total number of boxes in an invoice. Next I have a calcualted field that determines the number of pallets a given invoice will require based on the summary field.

When I put these fields into a sub-summary based on Invoice ID the summary of boxes field works correctly, but my pallet calculation gives me the total pallets for every invocie in the review. (IE its calculating based on the total boxes in the found set)

Not sure what going on here...

An example of my report (where you can get 4 boxes per pallet)

What I get:

Invoice Boxes Pallets

123 16 9

232 8 9

838 12 9

What I want:

Invoice Boxes Pallets

123 16 4

232 8 2

838 12 3

Use the GetSummary() function.

Create an account or sign in to comment

https://fmforums.com/topic/75893-issue-with-calculated-field-that-utilizes-a-summary-field/
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.