Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)