Thanks!
No.
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.