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
Updated 5 days ago