Overview
NOT is used to evaluate whether the expression meets a certain condition. If it belongs, the result is 0. If not, the result is 1.
Syntax | NOT(conditional expression) | Perform a negation operation on the result of the conditional expression. |
Parameter 1 | Conditional expression | The result of the conditional expression must be a Boolean or numerical type and cannot be omitted. |
Notes
The parameter must be Boolean type or numerical type.
True and false can be either in capital letters or small letters, and both of them are highlighted in blue.
Example
Create a subject and upload the example data: Contract Information. Filter out the non-standing agreements and calculate their contract volumes.
1. Use the IN function to find the standing agreements.
If the value of Contract Type is Standing Agreement or Standing Agreement Order, the contract is a standing agreement. Enter the formula: IN(Contract Type, "Standing Agreement Order", "Standing Agreement").
Note: The Contract Type in the formula is not entered manually. Instead, you can select it by clicking the field on the left.
2. Use the NOT function to find the non-standing contracts. Enter the formula: NOT(Whether the Contract Type is a Standing Agreement).
3. Calculate the contract volume of non-standing agreements. Add a calculation indicator, and enter the formula: DEF_ADD(SUM_AGG(Contract Volume,[],Non-standing Agreement).
Display the data in the component.
Display as the following image with KPI indicator card.
More examples:
Formula | Result | Note |
NOT(1-2>0) | 1 | / |
NOT(IN(City,"Tokyo","New York"))： | Rows with city field values that do not equal to Tokyo or New York = 1, all other rows = 0. | / |
