Derived Columns
Derived Columns Operators
Derived Columns
Derived Columns Operators
An overview of the operators used in derived columns, including arithmetic, comparison, logical, and constant operators. These operators allow users to perform a variety of operations, from basic arithmetic calculations to logical evaluations, enabling dynamic data manipulation.
| Operator | Syntax | Purpose |
|---|---|---|
| + | value_1 + value_2 | Adds value_1 and value_2. |
| - | value_1 - value_2 | Subtracts value_2 from value_1. |
| * | value_1 * value_2 | Multiplies value_1 and value_2. |
| / | value_1 / value_2 | Divides value_1 by value_2. |
| Any data type | ||
| = | value_1 = value_2 | Returns Yes if value_1 is equal to value_2, and No otherwise. |
| != | value_1 != value_2 | Returns Yes if value_1 is not equal to value_2, and No otherwise. |
| Numbers, Dates, String | ||
| > | value_1 > value_2 | Returns Yes if value_1 is greater than value_2, and No otherwise. |
| < | value_1 < value_2 | Returns Yes if value_1 is less than value_2, and No otherwise. |
| >= | value_1 >= value_2 | Returns Yes if value_1 is greater than or equal to value_2, and No otherwise. |
| <= | value_1 <= value_2 | Returns Yes if value_1 is less than or equal to value_2, and No otherwise. |
| Logical | ||
| AND | value_1 AND value_2 | Returns Yes if both value_1 and value_2 are Yes, and No otherwise. |
| OR | value_1 OR value_2 | Returns Yes if either value_1 or value_2 is Yes, and No otherwise. |
| NOT | NOT value | Returns Yes if value is No, and No otherwise. |
| Constant | Meaning | |
| yes | TRUE | |
| no | FALSE | |
| null | No value | |
| ^ | value_1^value_2 | Caret symbol (^) is used to represent the exponentiation operator, which raises a number to a power. |
Was this page helpful?