You can use these operators, constants, and Boolean literals in your transformation column formulas.
See Anaplan Data Orchestrator functions for the types of functions and formats you can use in your column formulas.
Operators and constants
Use operators in your formulas to combine, compare, and perform mathematical or logical operations with your data. Use the constants TRUE and FALSE as the result of conditional calculations. TRUE and FALSE resolve to Boolean.
For more information about operators and constants, see Operators and constants.
| Operator | Valid operation |
| + | number + number |
| - | number - number date - date timestamp(or date) - timestamp |
| * | number * number |
| / | number / number |
| > | number > number date > date |
| < | number < number date < date |
| >= | number >= number date >= date |
| <= | number <= number date <= date |
| = | number = number boolean = boolean date = date text = text |
| <> | number <> number boolean <> boolean date <> date text <> text |
| & | text & text |
| AND | boolean AND boolean |
| NOT | NOT boolean |
| OR | boolean OR boolean |
| TRUE | boolean = TRUE |
| FALSE | boolean = FALSE |
| NULL | number = NULL boolean = NULL date = NULL text = NULL |
Boolean literals
When boolean-like string and number values are used in expressions or operators that expect a boolean type, they're interpreted as boolean values. This interpretation can be convenient if a dataset naturally contains these string or numeric boolean representations, as they don't need to be converted.
All rows must contain a supported boolean literal, as any occurrence of an unsupported value results in an error when you attempt to query the view.
| Boolean result | Supported literals (case-insensitive) |
| True | TRUE "t" "true" "y" "yes" "1" 1 |
| False | FALSE "f" "false" "n" "no" "0" 0 |
| Unknown | NULL |
Operator and data type results
This table describes the resulting Anaplan Data Orchestrator (ADO) data type when you combine operands of different data types (Operand1 and Operand2 in the table) and these operators: +, -, *, /
Example: <Operand1> <Operator> <Operand2> = <ADO data type>
| Operand1 | Operand2 | ADO data type | Notes |
| integer | integer | integer | Integer arithmetic. Division truncates fractional part. |
| integer | float | float | Promoted to float. Result supports fractional output. |
| float | integer | float | Promoted to float. Result supports fractional output. |
| float | float | float | Floating-point arithmetic. |
| integer | literal | integer | ADO removes the fraction and displays the value as an integer. Examples:
|
| Integer | float-returning function | float | Function returns result to float when mixed with integer. Example: |
