Skip to main content
Question

Am getting syntax error while using the formula

  • February 8, 2022
  • 1 reply
  • 31 views
P
Level 0
Forum|alt.badge.img+7

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) &lt; ] at line 1. Please refer to PQL documentation for available syntax.

1 reply

florian.mrkvi
Level 7
Forum|alt.badge.img

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?
Community Code of ConductAccessibility statement