Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
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:
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 ) )