Operators
All operators have analogs among functions. In each case you can use the most appropriate option.
Template of using binary operators: <Operand A> <operator> <Operand B>
Template of using unary operators: <operator> <Operand B>
As operands of the operators, you can pass numeric scalars, numeric functions, math constants, boolean
scalars, boolean functions, or a column name. To pass a column cell, you can use the syntax ${columnName}
. Other ways
to use operands: true
, false
, PI
, E
etc.
Operators and functions can organize expressions as complex as you like. You can also use parentheses to change the standard sequence for evaluating operators. For example:
Sin(PI / 6) * (17 - ${LENGTH}) < 9 // The result is a boolean value
Operator List:
Here
A
is the left operand of the operator and theB
is the right operand.
Operator | Description | Similar Function |
---|---|---|
/ | The result of dividing A by B | Div(A, B) |
* | The product of A and B | Mul(A, B) |
% | The remainder of dividing A by B | Mod(A, B) |
^ | Returns A to the power of B | Pow(A, B) |
+ | The sum of two numbers A and B | Add(A, B) |
- | The difference between A and B | Sub(A, B) |
== | True if A equal to B and false otherwise | Eq(A, B) |
!= | False if A equal to B and true otherwise | NotEq(A, B) |
> | True if A is greater than B and false otherwise | Greater(A, B) |
< | True if A is less than B and false otherwise | Smaller(A, B) |
>= | True if A is greater than or equal to B and false otherwise | NotSmaller(A, B) |
\<= | True if A is less than or equal to B and false otherwise | NotGreater(A, B) |
and | Logical conjunction of boolean A and B | And(A, B) |
&& | Logical conjunction of boolean A and B | And(A, B) |
or | Logical disjunction of boolean A and B | Or(A, B) |
xor | Logical exclusive disjunction of boolean A and B | Xor(A, B) |
not | Logical negation of the B | Not(B) |
! | Logical negation of the B | Not(B) |
in | In operator, A in [A,B] returns true | In(A, B) |