I am trying to filter the orders that have a partial delivery. Currently I have created a record for this to identify them but now I am unable to transform it into a filter, so I can apply it to tables where I have sales orders that need to be filtered to see only the partially delivered ones.
So I tried several ways to do this but it seems I am unable to find the right way.
FILTER (CASE WHEN MATCH_ACTIVITIES (NODE_ANY Y'Delivery at Customer']) = 1 THEN 1 ELSE 0 END)
/COUNT("VBAK"."SUBMI") < 1;
You cannot use COUNT inside a FILTER statement try using PU_COUNT for the same.
You cannot use COUNT inside a FILTER statement try using PU_COUNT for the same.
Hello! I tried but unfortunately it's still not working.
I tried with FILTER (MATCH_ACTIVITIES (NODE_ANY 'Delivery at Customer']) = 1);
FILTER PU_COUNT("VBAK", "VBAK"."SUBMI") < 1;
The issue is that I need to see all the orders which are partially delivered and then create another filter to see orders which are partially delivered 80% but I am stuck on the first step.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
