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.

Sub-summary report needing to show value where none exists

321
in Printing

Featured Replies

Hi all,

I have a sub summary report I would like to display 0 values on. It is a simple table that is summarized by product category with an amount for each category. Filemaker only summarizes what is in the found records. I would like it to summarize all 4 product categories even though some product categories have no value in the amount field to summarize. See the example below.

This is how it summarizes:

Category Amt

Product A $1000

Product C $2000

This is how I would like it to summarize:

Category Amt

Product A $1000

Product B $0

Product C $2000

Product D $0

Any advice would be greatly appreciated.

Thanks!

Eric

A subsummary report can not group on values that do not exist. That being said, you may be able to generate a report like this from your products table if your solution is properly structured.

Create an account or sign in to comment

https://fmforums.com/topic/83423-sub-summary-report-needing-to-show-value-where-none-exists/
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.