Excluding data
When formulating a filter condition, you can use comparison operators, such as Equal to, Greater Than, or Less Than, to determine which data to view. Sometimes it is more efficient to specify a condition that excludes a small set of data. For example, you need sales data for all countries except the USA. Instead of selecting all the available countries except the USA and listing them in the filter condition, it is simpler to use the Not Like operator to exclude data that matches a string pattern. Similarly, use the Not Between operator to exclude numeric data in a specific range.
For example, the following filter condition excludes orders with amounts that are between 1000 and 5000, inclusively. The filter condition excludes 1000 and 5000.
OrderAmount Not Between 1000 And 5000
The filter condition in the following example excludes products with codes that start with MS:
ProductCode Not Like MS%

Additional Links:

Copyright Actuate Corporation 2012