Finale has the ability to use "Include" and "Exclude" operators as well as the ability to filter including or excluding blank values for the field filters on list views, reports, and automation rules.
How to Use
Any field that has the turn down arrow supports this functionality. Using the turn down arrow, select which operator you want to use and then choose your value (or type your value) in the filter.
Operator Details
Include Matching: This option is the traditional behavior. All matches to the filter value will display. This is an OR filter, so if you choose several options, it will display ANY result that matches one or more of the filter values.
Excludes Matching: This option is the opposite of Include. Any row that contains any of the values in the filter will be excluded from the result.
Include Blank Values: This option will include rows that have no value. To use this, a value must be entered into the filter. It does not work to only show blanks if this option is selected and no value is entered into the filter.
Exclude Blank Values: This option will exclude rows that have no value. To use this, a value must be entered into the filter. It does not work to exclude blanks if this option is selected and no value is entered into the filter.
Examples
Tags
Scenario: Filter to orders that have the tag "TikTok"
Configuration: Filter set to "Include Matching" and "Exclude Blank Values". Choose tag and search.
This will return all orders that have the tag TikTok only.
Shipping Speed
Scenario: Processing orders for shipping that are expedited shipping. Filter out orders that are standard shipping.
Configuration: Filter set to "Exclude Matching" and select the ground option. "Exclude Blank Values".
This will return any order that does not have a ground option specified. Ideal if there are several expedited shipping options (next day, 2nd day, expedited) but only one ground option.