This is what I’ve been able to build but I want to make section that gives me a final number of how many I can build. Not have it show me what the lowest number in stock that I have. I want to see a section that says I can only build 6.
Solved
Is there a way that I can create a generic Inquiry to estimate of how many of a particular sub-assembly can be made from the on-hand materials?
Best answer by lauraj46
Hi
To return the minimum value per BOM ID, you should group on the BOM ID and top level assembly fields on the Grouping tab. Then specify MIN as the Aggregate Function on the “Qty Capable to Build” formula field. You may need to add the Aggregate Function with the column selector if it’s not showing in the Results Grid of the GI builder.
Depending on your requirements, the Report Designer could also be an option to accomplish this.
+8Hi
To return the minimum value per BOM ID, you should group on the BOM ID and top level assembly fields on the Grouping tab. Then specify MIN as the Aggregate Function on the “Qty Capable to Build” formula field. You may need to add the Aggregate Function with the column selector if it’s not showing in the Results Grid of the GI builder.
Depending on your requirements, the Report Designer could also be an option to accomplish this.
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.