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.
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.
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.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy