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 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