FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice' ] ) = 0;For the above filter, i would like to use the AND function and include both of the activities for filtering the data.

instead of NODE you can use NODE_ANY and then specify the additional activities in the [] e.g.

FILTER MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice', 'Process invoice' ] ) = 0;

• NODE: case has to have the specified activities
• NODE_ANY: case has to have at least one of the specified activities
  • FILTER MATCH_ACTIVITIES ( "Table1"."ACTIVITY" , NODE_ANY [ 'B' , 'C' ] ) = 1;

https://docs.celonis.com/en/match_activities.html

Thank you very much Sunny for your support. Is it possible to convert this filter into a KPI?

I usually use a CASE WHEN statement to evaluate whether the formula is true and then and a count or sum around the top. e.g.

COUNT(CASE WHEN MATCH_ACTIVITIES ( "<your activity table>"."<your activity column>" , NODE [ 'Clear Invoice', 'Process invoice' ] ) = 1 THEN 1 ELSE 0 END)

Thank you Sunny. I will try this out and let you know the outcome.

Yeah, let me know how you get on, and confirm if this is what you were looking for.

Hi Sunny,

I tried the below But, i am not able to get the results.

COUNT(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE_ANY [ 'Create Billing Document/Invoice', 'Set Reason for Rejection' ] ) = 1 THEN 1 ELSE 0

'OR'

COUNT(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE ['Cancel Reason for Rejection'])=0 THEN 0

ELSE 1 END)

think you have a syntax error. You may want to try the formula out in sections. I see that you are missing some brackets and END for the first CASE WHEN statement. Also "or " is an equaluator. So should have been used within the CASE WHEN. Think the below will work for you:

SUM(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE_ANY [ 'Create Billing Document/Invoice', 'Set Reason for Rejection' ] ) = 1 THEN 1 ELSE 0 END)

+

SUM(CASE WHEN MATCH_ACTIVITIES ( "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" , NODE ['Cancel Reason for Rejection'])=0 THEN 0 ELSE 1 END)

Thank you so much Sunny. This worked

not an issue. feel free to mark this question as answered.