Difference in Empty Value Handling Between FineBI 6.1 and 6.0

The main differences between FineBI 6.1 and 6.0 lie in the handling of Null, empty strings (""), and NAN. The three types of empty values seem to be the same, but are handled differently in actual calculations.

Concept description of the three types of empty values:

The following lists the differences between the three types of empty values in different calculations. The differences are mainly reflected in the dashboard calculation results.

Note:

The new minor version of FineBI 6.0 has been continuously updated and iterated to synchronize with the functions of FineBI 6.1. The following lists calculation results of some functional scenarios where the calculation results are already consistent with those in FineBI 6.1.

Difference in Arithmetic Operations After the Removal of NAN in FineBI 6.1

Application Scenario

New calculation rules in FineBI 6.1:

• Null is treated as 0 in arithmetic operations.

• Any result involving NAN will be NAN in arithmetic operations.

Example

6.1
6.0

Solution

If you want to achieve the same efficiency as before, you can use the IF function for evaluation.

For example, the formula 1-num/num1 can be modified to IF(num/num1=null,Null,1-num/num1).

Distinguishing Null and Empty Strings ("") in Grouping Scenarios in FineBI 6.1

Application Scenario

Null and empty strings ("") are distinguished in FineBI 6.1.

Null and empty strings ("") are not distinguished in FineBI 6.0.

Example

6.1
6.0

Null Included in Sorting in FineBI 6.1

Application Scenario

Null is included in sorting in FineBI 6.1.

Null is not included in sorting in FineBI 6.0.

Example

6.1
6.0