Hello Everyone,

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

As

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

With regards

Rahul