| Operators |
The following operators can be used in filtering when creating an expression.
| Available Operators | ||
|---|---|---|
| + Addition | x + y | Used to add. |
| - Subtraction | x - y | Used to subtract. |
| - Unary Minus | -x | Used to make a negative number. |
| * Multiplication | x * y | Used to multiply. |
| / Division | x / y | Used to divide. |
| ^ Exponentiation | x ^ 3 | Used to indicate Exponentiation. |
| = Equals to | x = y | Used to compare equality between two values. |
| < Less than | x < y | Used to compare if the first value is less than the second value. |
| <= Less than or equal to | x <= y | Used to compare if the first value is less than or equal to the second value. |
| <> Not equal to | x <> y | Used to compare two values and prove they are not equal. |
| != Not equal to
(same as <>) |
x ! = y | Used to compare two values and prove they are not equal. |
| >= Greater than
or equal to |
x >= y | Used to compare if the first value is greater than or equal to the second value. |
| > Greater than | x > y | Used to compare if the first value is greater than the second value. |
| CONTAINS | STATE contains "NY" | Variable contains string. |
| IN | "NY" in
STATE |
String within variable. The string must appear first. |
| AND | x and y | Logical and |
| NOT | not
INACTIVE |
Logical negation |
| OR | x or y | Logical or |
| Hierarchy of Math Operators | |
|---|---|
| 1 | Parentheses |
| 2 | Exponentiation |
| 3 | Multiplication & Division |
| 4 | Addition & Subtraction |
| 5 | Relational Operators (left to right) |
| Hierarchy of Comparison Operators | |
|---|---|
| 1 | NOT |
| 2 | AND |
| 3 | OR |
| 4 | CONTAINS or IN |