NOT (Report Builder)
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. . |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Logical Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)