Skip to main content

Good day

I want to add a filter to this table that shows only the Functional locations (first column) where one of the Material_IDs has a Physical count of 0. Then it must show all the Materials for that Functional location even if its not 0. So the criteria is 1 or more of the materials in the Functional location must be 0 then that functional locational with its other materials should be shown. Below is an example in yellow: Both functional locations A-IAA-BO4-225-HEC-008’s material id must be shown here since one of them is 0. How can I do that?

 

 

I found the answer: 

FILTER PU_MIN ( DOMAIN_TABLE("o_custom_WorkOrder"."FunctionalLocationConverted"),

BIND("o_custom_MaterialReservation",filter_TO_NULL("o_custom_MaterialMasterMRPArea"."PhysicalCount")) ) = 0


Reply