Operator is used to specify the type of calculation to perform on the elements in the formula. There is a default calculation order, but you can change this order using parentheses.
There are four different types of evaluation operators: arithmetic, comparison, logic, and string splicing.
Perform basic mathematical operations, such as addition, subtraction, multiplication, division, etc., and use the following arithmetic operators in the formula:
*(Multiply)
= 3 * 3
9
/(Divide)
= 15 / 3
5
%(Remainder)
= 20 % 6
2
= 3 ^ 2
You can compare two values using the following operators. When these operators are used to compare two values, the result is a logical value of "TRUE" or "FALSE".
=(Equal sign)
Equal
A1 = B1
>(Greater than sign)
Greater than
A1 > B1
<(Smaller than sign)
Less than
A1 < B1
>=(Greater than or equal to sign)
Greater than or equal to
A1 >= B1
<=(Less than or equal to sign)
Less than or equal to
A1 <= B1
!=(Unequal sign)Note: it is different from < > in Excel.
Unequal to
A1 != B1
Logical operators are used in the same way as "AND" and "OR".
Logical and, satisfying multiple expression conditions at the same time
Note: logical operators can only connect two boolean or numeric expressions.
You can use the "+" operator to merge text fields。
For example, the text fields "store style" and "store name" can be spliced together. Of course, the CONCATENATE indicator can be used, but a simpler scheme is to directly use "+", as shown in the following figure:
In some cases, the order in which calculations are performed may affect the return value of the formula, so you must know how to determine the order and how to change the order to obtain the desired results.
If there are several operators in a formula, FineBI will calculate in the order in the following table. If several operators in a formula have the same priority (for example, if a formula has both a multiplication sign and a division sign), finebi will calculate the operators in the following direction.
-
Minus
-Para
From right to left
From left to right
Multiply
Divide
Remainder
Plus
Para=Para
Para==Para
Logical AND
Logical OR
To change the calculation order, you need to enclose the part of the formula to be calculated first in parentheses.
For example, the following formula generates 11 because multiplication is calculated before addition. The formula first multiplies 2 and 3, and then adds 1 and 4 to the result.
=1+2*3+4
However, if you change the syntax with parentheses, you add 1 and 2 together, then multiply the result by 3, and then add 4 to get 13.
=(1+2)*3+4
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy