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 the B 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)