Am getting syntax error while using the formula | Community

Formula :

COUNT(DISTINCT CASE WHEN KPI(TAT) < <%=SLA%> THEN "PurchasingExample_Test_csv_CASES"."CASE ID" ELSE NULL END)

Error :

Syntax error near THEN] after reading TABLE (COUNT(DISTINCT CASE WHEN KPI(TAT) < ] at line 1. Please refer to PQL documentation for available syntax.

Page 1 / 1

Hi!

I am not sure what you are trying to do here: WHEN KPI(TAT) < <%=SLA%>

Can you tell us

what KPI(TAT) returns? A list of numbers or just one number? And which data type?
what kind of data SLA holds?

Reply