A: No, the field needs to be selected in the field selection box on the left, and cannot be entered manually. For details, see: Function calculation format.
A: !=. For details, please refer to: calculation operators and precedence.
A: Need to add "double quotation marks for English input method" around the text expression. For details, see: Function calculation format.
A: All punctuation marks such as commas and parentheses need to use the "English input method".
A: Troubleshoot the reason for the illegal formula.
A: Yes.
A: No.
A: IF function and OR, AND function nested use/multiple IF functions nested use. For details, see: Multi-conditional assignment.
A: The extracted data is not distinguished, and the real-time data depends on each database type. To ensure the accuracy of the formula, it can be written in a format such as: IF (house type=""||house type=null, building nature, house type).
A: Logical and logical or usage is the same as AND and OR.
For example, the formula: IF(house type=" "||house type=null,building type,apartment type) is the same as IF(OR(house type=" ",apartment type=null),building type,apartment type). Both mean if the apartment type is empty or blank , then return the data corresponding to the "building property" field, otherwise return the data corresponding to the "house type" field.
A: Divide when the numerator/denominator is 0.
A: len(field)!=0
A: One is a time field and the other is a text field. You need to convert the text field into a time field. Use the date function: Access time>DATE(2020,12,1)
A: 'Counter" is actually COUNT_AGG (Counter), which is already an aggregate function. The aggregate function cannot be nested with the AVG_AGG() aggregate function.
A: Need to use logical AND() or "&&". For example: start date<NOW()&&NOW()<end date.
A: DATEDIF or DATESUBDATE function.
A: The indicator field creation formula after detail filtering only supports the use of aggregate functions.
A: Use the IF function to calculate the aggregate function twice. When the formula contains non-aggregated fields, the formula is illegal. For details, see: Troubleshooting for illegal formulas Section 3.2.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy