Hello All, I am trying to get a KPI PQL statement for SAP field KDATE(Date) when the date in the field = 9999-12-31 Has anyone done PQl statements like this before? Thanks for your help in inadvance

Hello, yes, you can achieve that in Celonis.

I am not fully sure what information exactly you want to achieve but probably one of this 2 possibilities will solve the issue:

Imagine you want to get the number of cases where KDATE = 9999-12-31

-> using CASE WHEN: Here, the case when will work exactly like in SQL and iterate only by those cases that comply with the condition KDATE = 9999-12-31 SUM(case when "EKPO"."KDATE" = '9999-12-31' then 1 else 0 end)

-> using a Component Filter: Here you can create a KPI that displays the number of cases (PQL: COUNT_TABLE("EKPO")) and then add a filter on top so that only those with EKPO.KDATE = 9999-12-31 appear (PQL: FILTER "EKPO"."KDATE" = '9999-12-31')