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