Title
omit sub summary line items if below a threshhold value?
Post
i'm still getting acquainted with sub summary reports.
i was wondering if it is possible to exclude items from the report if the sub summary is below a certain vaule.
basically i wish to not show items with a sub summary count of less than 2.
i thought i could do this with a search but sub summary fields do not seem to be searchable.
i arrive at the sub summary by executing a script which searches my records for a date range and then send the user to the sub summary layout.
Summary field values do not refer to a specific record (they refer to a group) and their value changes as the found set changes so that keeps them from being a searchable field.
By defining a field that uses GetSummary to return the same subtotal as your sub summary parts, you could set up a script that uses omit record to loop through your found set and omit all records where this calculation field returns 2 or smaller.