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.

Total Prices from multiple records in a Portal

Featured Replies

I have a portal that has multiple records and each one has a unique ID. Sometimes it is necessary to have 2 of the same records in the portal, in the image for instance 2 delivery records are sometimes needed, yet in the total field (which is from the layout called invoices, the portal is from NonSerial Inventory) which has a calculation of Sum (tbl_NonSerial_Inventory::NonSerial Price)

Yet, it will not sum the price if there is more than 1 of the same item. I'm not sure why, unless it won't add it because it is the same record? Any help would be appreciated. Thanks - Jeff

portal.jpg

I suspect your portal is not showing what you think it should show. Make sure it's pointed at the correct table occurrence, and that the fields in the portal are also from the same TO.

I'm a little confused when you say "because it is the same record". The 2 portal rows are obviously 2 records. Is is possible that your calculation is pointing "thru" the portal, to a "inventory" table (which has only 1 record for this "product")?

Yeah, that's more likely.

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.