BAQ Multiplying Demand by number of active bins

Creating a BAQ to Show our current Demand. The Issue I am having is now we have multiple bins for the same part number and the Demand Qty is for the total part. This causes it to multiply my demand by however many bins are active on a part. how do I only show the demand once?

Make a subquery that groups and sums the quantities, then feed that subquery in instead of use the raw table.

Also, what do you need the bins for? Demand is independent of bins.

1 Like