Skip to main content
How to filter on count formula results? I'm trying to create a 'COUNTIF' PQL, something like this FILTER(COUNT("LFA1"."NAME1") >2 ). Is this possible in Celonis?
Thanks!

No.

imageimage


No.

imageimage

imageimage


Hi Lucian,

 

Regular aggregations like COUNT/SUM/AVG do not work with the component/load script filters, as Omer showed above - you will have to use a PU_COUNT aggregation to the Cases level to successfully filter your analysis/component.

 

In your case (assuming it's a P2P data model) your expression should look something like this:

 

FILTER PU_COUNT(EKPO, LFA1.NAME1) >2;

 

This filter will limit your dataset to PO Items where there are more than 2 vendor names per PO Item. However, please bear in mind that you might not see any cases, since the relationship between EKPO and LFA1 is usually 1:1

 

Please upvote if helpful

Thanks!

 

Eugene

Ashling Partners

 


Reply