Operators supported in conditional formatting and filter condition expressions
Table 4-5 lists the operators you can use when you create expressions for conditional formatting and filter conditions.
Test if a column value is equal to any one of the specified values.
Country Any Of USA, Canada, Mexico
Bottom Percent
Test if a column value is in the bottom n percent of all values.
Test if a column value is greater than a specified value.
Greater Than or Equal to
Test if a column value is greater than or equal to a specified value.
Test if a column value is not a null value. A null value means no value is supplied.
Test if a column value is less than or equal to a specified value.
Month to Date Last Year
Test if a column value matches a date value and displays last year’s values.
Test if a column value is not between two specified values.
Test if a column value is not equal to any one of the specified values.
Country Not In USA, Canada, Mexico
Test if a column value does not match a string pattern.
Quarter to Date Last Year
Test if a column value matches a date value and displays last year’s values.
Year to Date Last Year
Test if a column value matches a date value and displays last year’s values.
 
 

Additional Links:

Copyright Actuate Corporation 2012