I’m hoping someone is able to assist with this. We are trying to build a Bill of Materials for our products. I have a Products and Parts tab. The Products tab pulls the list of parts from the Parts tab using ‘Link to Parts’ and totals the costs using ‘Roll-up’ to determine our cost per product. However, the issue I run into is when some of the products have multiple of the same part. I can’t find a way to make this work as the roll-up formula I am using only pulls one of each of the listed parts, while I need it to pull multiples of specific parts for an accurate total.
What it does now: 1x screw, 1x case, 1x cable
What I need: 6x screws, 1x case, 2x cable