反馈已提交
网络繁忙
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后关闭