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.




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