Celonis represents unknown or non-existing values as NULL. It is important to mention that it is not a data type of its own, but it can be used in all columns independent from the data type. In order to check the exact NULL behavior of certain operators, please refer to their documentation.
Typical NULL behavior
- Aggregations usually ignore NULL values.
- Calculations usually return NULL if the input value is NULL.
- If there are for a certain group/case only NULL values, the result is usually NULL.