Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
<input> IS NULL
evaluates to true when the input is NULL, and false otherwise.
The output can be negated by using <input> IS NOT NULL
.
IS NULL should not be confused with the predicate function ISNULL, which returns an INT instead of a boolean.
IS [NOT] NULL
can be used in the following contexts:
- CASE WHEN (in the
WHEN
conditions) - FILTER
- Pull-Up-Functions (in the filter argument)
- BIND_FILTERS (in the filter argument)
- CALC_REWORK (in the filter argument)
Syntax
input IS NULL
input IS NOT NULL
Examples
[3]
IS NOT NULL
in a PU_SUM context,
specifically the filter part of the Pull-Up-Function.
Query
Column1
"companyDetail"."companyCode"
Column2
PU_SUM ( "companyDetail" , "caseTable"."value" , NOT ( "companyDetail"."country" IS NOT NULL ) )