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.

Table 4-5

Operators supported in conditional formatting and filter condition expressions

Operator	Use to	Example
Any Of	Test if a column value is equal to any one of the specified values.	Country Any Of USA, Canada, Mexico
Between	Test if a column value is between two specified values.	Profit Between 1000 and 2000
Bottom N	Test if a column value is among the lowest n values.	SalesAmount Bottom N 10
Bottom Percent	Test if a column value is in the bottom n percent of all values.	SalesAmount Bottom Percent 5
Equal To	Test if a column value is equal to a specified value.	Country Equal To France
Greater Than	Test if a column value is greater than a specified value.	Total Greater Than 5000
Greater Than or Equal To	Test if a column value is greater than or equal to a specified value.	Total Greater Than or Equal To 5000
Is False	Test if a column value is false.	LoanApproved Is False
Is Not Null	Test if a column value is not a null value. A null value means no value is supplied.	CreditLimit Is Not Null
Is Null	Tests if a column value is a null value.	CreditLimit Is Null
Is True	Test if a column value is true.	LoanApproved Is True
Less Than	Test if a column value is less than a specified value.	Total Less Than 5000
Less Than or Equal To	Test if a column value is less than or equal to a specified value.	Total Less Than or Equal To 5000
Like	Test if a column value matches a string pattern.	ProductName Like %Ford%
Month to Date	Test if a column value matches a date value.	Month to Date 3/15/2011
Month to Date Last Year	Test if a column value matches a date value and displays last year’s values.	Month to Date Last Year 3/15/2011
Not Between	Test if a column value is not between two specified values.	Profit Not Between 1000 and 2000
Not Equal To	Test if a column value is not equal to a specified value.	Country Not Equal To France
Not In	Test if a column value is not equal to any one of the specified values.	Country Not In USA, Canada, Mexico
Not Like	Test if a column value does not match a string pattern.	ProductName Not Like %Ford%
Quarter to Date	Test if a column value matches a date value.	Quarter to Date 3/15/2011
Quarter to Date Last Year	Test if a column value matches a date value and displays last year’s values.	Quarter to Date Last Year 3/15/2011
Top N	Test if a column value is among the top n values.	SalesAmount Top N 10
Top Percent	Test if a column value is in the top n percent of all values.	SalesAmount Top Percent 5
Year to Date	Test if a column value matches a date value.	Year to Date 3/15/2011
Year to Date Last Year	Test if a column value matches a date value and displays last year’s values.	Year to Date Last Year 3/15/2011

 

 

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2