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 rows 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 USA. Instead of selecting all the available countries except USA, and listing them in the filter condition, it is simpler to use the Not Equal To operator. Similarly, use the Not Between operator to exclude data in a specific range, and the Not Like operator to exclude data that matches a string pattern.
For example, the following filter condition excludes orders with amounts that are between 1000 and 5000:
OrderAmount Not Between 1000 and 5000
The filter condition in the next example excludes products with codes that start with MS:
ProductCode Not Like MS%

Additional Links:

Copyright Actuate Corporation 2012