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