The KPI is : COUNT_TABLE("EKPO") and I have added the next component filters
FILTER "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" NOT IN (<%=Blacklist_Activities%>); (this one works)
FILTER "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" NOT IN (INDEX_ACTIVITY_TYPE <%=Rework_activity_more_than_1%> > 1); (this one is the one that doesn't work. Error: Missing '('
Hi @marilyn.torta,
You can use the CALC_REWORK statement here to achieve your goal. It counts the number of activities per case that you specify.
It would look something like this in your situation.
FILTER CALC_REWORK("_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" NOT IN (<%=Rework_activity_more_than_1%>) > 1;
Let me know if this worked!
Kind regards,
Sverre Klein
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
