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.

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