NOT( )

Negates a Boolean expression.

Syntax

NOT(x)

Argument

x

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( ) function. It tests if the value in the State field is not CA. If the value is not CA, it returns the value in the Markup field multiplied by 10%, and by 15% if it is.

IF(NOT([State]="CA"),[Markup]*10%,[Markup]*15%)

The previous IF( ) expression is semantically equivalent to the following expression:

IF([State]="CA",[Markup]*15%,[Markup]*10%)

Copyright Actuate Corporation 2012