Check for illegaltimacy reason of the formula

1.1 Problem description

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.

1.2 Reason analysis

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.

3.1 Error using aggregation function

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：

3.2 Calculated field formulas report errors

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.