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%)

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

BIRT iHub 2