An operator is a character that represents an action. Use an arithmetic operator to perform mathematical calculations or a Boolean operator to work with true and false values. Operators can be used with all data types.
Note
Not all functions are supported between Standard mode and Cloud Native mode tools. For a list of supported functions, go to the respective Standard mode and Could Native mode function lists found on the Formula tool page.
This table shows the established order of operator groups. Operations within a group bind left to right.
Order | Operators |
---|---|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
+
: Use the addition operator to add multiple numeric values together. In addition, you can concatenate strings.
AND
: Combines 2 Boolean values. The result is True if both of the combined values are True, False if either of them is False but not NULL, and NULL if either of them is NULL.
&&
: Combines 2 Boolean values. The result is True if both of the combined values are True, False if either of them is False but not NULL, and NULL if either of them is NULL. Boolean AND does not follow normal precedence rules but goes left to right. For example,A&&B||C
is True for ABC=(011), butC||A&&B
is evaluated as(C||B)&&A
, and this expression is false on (011).
NOT
: Accepts 1 input. If that input is True, it returns False. If that input is False, it returns True. If that input is NULL, it returns NULL.
!
: Accepts 1 input. If that input is True, it returns False. If that input is False, it returns True. If that input is NULL, it returns NULL.
OR
: Combines 2 Boolean values. The result is True if either (or both) of the two values is true. Returns NULL if any of the values is NULL.
||
: Combines 2 Boolean values. The result is True if either (or both) of the two values is true. Returns NULL if any of the values is NULL. Boolean OR does not follow normal precedence rules but goes left to right. For example,A&&B||C
is True for ABC=(011), butC||A&&B
is evaluated as(C||B)&&A
, and this expression is false on (011).
/
: Use the division operator to divide a numeric value by another numeric value. Division is always done as a double, even if the result might happen to be an integer:
6 / 3
returns a double (2), even if 6 and 3 are integers.7.5 / 2.5
returns a double (3).
=
: Equal To. Note that Designer Cloud also accepts==
for equal to.
>
: Greater than.
>=
: Greater than or equal.
<
: Less than.
<=
: Less than or equal.
*
: Use the multiplication operator to multiply numeric values together.
!=
: Not Equal To
-
: Use the subtraction operator to subtract a numeric value from another.
IN ()
: (Test Value in List) Determines if a given value matches any value in a subquery or a list.
NOT IN ()
: (Test Value Not in List) Determines if a given value matches any valuenotin a subquery or a list.