Users sometimes use the formula when the formula is not legal, this chapter will provide users with some of these illegal when the way to troubleshoot.
Users can determine whether a formula is legal below the formula editing area, as shown below.
There are two main reasons for this.
1)The input punctuation and field format is incorrect.
2)The entered formula does not conform to BI's function logic.
The fields used in the formula need to be added by clicking on the fields on the left side, manual input is not legal, as shown in the following figure.
The symbols entered should be in English format, such as the common as shown below.
Aggregate functions are only used to calculate fields. For details of FineBI's aggregate functions, please see: Aggregate Functions
1)The schedule cannot use the aggregation function and reports an error as shown below.
2)The aggregation function cannot be used inside the aggregation function, otherwise the formula is not legal, as shown below.
3)Aggregate functions and aggregated fields cannot be calculated secondarily with non-aggregated fields.
For example, if you use the IF function to perform a secondary calculation on an aggregate function, the formula is not legal when the formula contains a non-aggregate field. As shown in the following figure.
However, aggregate functions can be nested with non-aggregate functions. sum_agg(max(field)) is legal, as shown below:
The fields used in the calculation field cannot have a detail filter.
For example, for the indicator "ORDERID", a new calculated field is created with the formula shown below.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy