Workflow Operators
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.
Order of Precedence
This table shows the established order of operator groups. Operations within a group bind left to right.
Order | Operators |
|---|---|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
Addition
+: Use the addition operator to add multiple numeric values together. In addition, you can concatenate strings.
Boolean AND - Keyword
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.
Boolean 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. Boolean AND does not follow normal precedence rules but goes left to right. For example,A&&B||Cis True for ABC=(011), butC||A&&Bis evaluated as(C||B)&&A, and this expression is false on (011).
Boolean NOT - Keyword
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.
Boolean 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.
Boolean OR - Keyword
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.
Boolean 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. Boolean OR does not follow normal precedence rules but goes left to right. For example,A&&B||Cis True for ABC=(011), butC||A&&Bis evaluated as(C||B)&&A, and this expression is false on (011).
Division
/: 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 / 3returns a double (2), even if 6 and 3 are integers.7.5 / 2.5returns a double (3).
Equal To
=: Equal To. Note that Designer Cloud also accepts==for equal to.
Greater Than
>: Greater than.
Greater Than or Equal
>=: Greater than or equal.
Less Than
<: Less than.
Less Than or Equal
<=: Less than or equal.
Multiplication
*: Use the multiplication operator to multiply numeric values together.
Not Equal To
!=: Not Equal To
Subtraction
-: Use the subtraction operator to subtract a numeric value from another.
Value IN (...)
IN (): (Test Value in List) Determines if a given value matches any value in a subquery or a list.
Value NOT IN (...)
NOT IN (): (Test Value Not in List) Determines if a given value matches any valuenotin a subquery or a list.