Example #1
This Filter example allows for the selection of only items sold before the beginning of 2018 with a low Quantity on Hand and a low Profit.
[INV:LastSold]<010118&&[INV:QOH]<=5&&[INVC:% Profit]<=30
The filter includes only items that were sold before 01/01/18 AND have a a Quantity-On-Hand of five units or less AND with a profit of 30% or less.
What this filter does:
- Compare each item's Last Sold date with the date 010118.
- Then it checks each item for a Quantity on Hand of five or less.
- Then it looks at the Profit to determine if it is less than or equal to 30%.
Filters may include general, logical, and arithmetic Operators (i.e. Greater Than, Equal Tto, Contains) as well as Functions such as And, Or, If-Then-Else, etc.
Operators and Functions may be combined to produce complex filters.
Example #2
A single filter, for instance, could select:
- Items with a QOH that is less than the Minimum Order Quantity, or
- Items with either List Price from $150.00 to $500.00 or Base Price from $100.00 to $450.00 and a QOH of 10 or less, or
- Items with a List Price of over $500.00 and a QOH of 5 or less, or
- Items with a Base Price of $1000.00 or more regardless of quantity, or
- Items with a description that begins with the word "Premium", regardless of price.
This filter looks like this:
[INV:QOH]<[INV:MinQty]||(([INV:ListPrice]>150&&[INV:ListPrice]<500)||([INV:Price]>100&&[INV:Price]<450)&&[INV:QOH]<10))||([INV:ListPrice]>500&&[INV:QOH]<5)||[INV:Price]>1000 ||[INV:Description] Premium*
See:
Filters and Formula Operators
Filters and Formula Functions
Filters - Transaction Types
Variables - Definition
Report/Label Editor Contents