NOT (Report Builder 1.0)
Returns TRUE if the argument is false; otherwise, returns FALSE if the argument is true.
Syntax
NOT(logical)
logical |
Indicates the condition to be tested. |
Remarks
Use NOT when you want to make sure value is not equal to one specific value.
To indicate NOT, you can also type <>.
If the condition is FALSE, NOT returns TRUE; if the condition is TRUE, NOT returns FALSE.
Example
Formula |
Result |
|---|---|
NOT(Name = "Tool crib") |
Returns TRUE for each instance of the Name field that returns a value other than "Tool Crib." If the Name field value equals 'Tool Crib," then FALSE is returned. . |