Skip to main content
Question

Filter showing all data in a range but one item is 0

  • February 28, 2025
  • 1 reply
  • 31 views

bennita.dutoi12
Level 7
Forum|alt.badge.img+6

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?

 

 

1 reply

bennita.dutoi12
Level 7
Forum|alt.badge.img+6
  • Author
  • Level 7
  • 17 replies
  • March 3, 2025

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