Operators overview

Sigma supports basic operators for calculations, evaluating them in accepted order. You can use these operators when developing the conditions of Logical functions.

Sigma supports the following operators:

Example

When calculating values, such as using the addition operator + to add two values, the result is Null if one of the values is Null.

\[Column 1\] + \[Column 2\]

If the value of [Column 2]Β  is Null, then the result of the entire formula is Null.

To resolve this, you can apply the Zn function to each value, to substitute 0 for Null:

Zn(\[Column 1\]) + Zn(\[Column 2\])

.
Class division notation. Used to navigate through the levels of Variant and JSON data types
+
Adds two numbers
-
Subtracts one number from another
*
Multiplies two numbers
/
Divides one number by another
^
Raises a number to the specified power
%
Modulo computes the remainder of dividing X by Y
&
Ampersand concatenates two strings together
<
Determines if X is less than Y
<=
Returns whether X is less than or equal to Y
>
Returns whether X is greater than y
>=
Returns whether X is greater than or equal to y
=
Returns whether x is equal to y
!=
Returns whether x is not equal to y
()
Used to change the order of operations
AND
Returns whether two logical values are both TRUE
OR
Returns whether either of two logical values are both TRUE
NOT
Negate a value or expression
TRUE
Interpreted as the Boolean literal TRUE
FALSE
Interpreted as the Boolean literal FALSE
NULL
Interpreted as a null literal