NOT( )
Negates a Boolean expression.
Syntax
NOT(expression)
Argument
expression
The Boolean value or expression to negate.
Returns
True if the expression evaluates to FALSE, and false if the expression evaluates to TRUE.
Example
The following example uses NOT( ) in conjunction with the IF( ) and LIKE( ) functions. It tests if the value in the State data field is not CA. If the value is not CA, it returns the value of the Markup data field multiplied by 10%. If the value is CA it returns the value of the Markup data field multiplied by 15%:
IF(NOT(LIKE([State], "CA")),[Markup]*10%,[Markup]*15%)
The previous IF( ) statement is semantically equivalent to the following statement:
IF(LIKE([State], "CA"),[Markup]*15%,[Markup]*10%)

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2