I hope you all doing good
I would like to see how many orders that are going through Credit Check. Normally, the credit check was executed on the Header level, which means we do not care about position lines. But in the Celonis the activity is defined from Order item not from the order header level.
In order to see the total number of orders that are going through credit check , I have implemented PQL code
COUNT((CASE WHEN “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” IN (‘Deny Credit Check’,‘Approve Credit Check’)
THEN " VBAK".“VBELN” ELSE NULL END))/COUNT_TABLE(“VBAK”)
But still it counts the activity.
Do you have any idea, how to count only sales orders for an activity by using any other function?
Thanks in Advance