Skip to main content
Question

I need a KPI that counts the number of POs that could have gone through a specific list of activities but not more than once (meaning these activities are OK to happen only one time)

  • February 28, 2024
  • 2 replies
  • 5 views
marilyn.torta
Level 2
Forum|alt.badge.img

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 '('

    2 replies

    Sverre Klein
    Level 10
    Forum|alt.badge.img+14
    • Sverre Klein
    • Level 10
    • February 29, 2024

    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

    Sverre Klein
    Level 10
    Forum|alt.badge.img+14

    Hi @marilyn.torta,

     

    I hope the above issue is resolved for you? 🙂

     

    Regards,

    Sverre

    Community Code of ConductAccessibility statement