How to display the number of items that are grouped together in a BOM

[NickHorton8970]

I am using the data from the BOM to populate a table on a drawing which I intend to use as a cutting list for timber required to manufacture the frames shown on the drawing.

i have successfully grouped the items together that i need based o nthe same width, thickness and length however i can only find inputs to represent the items numbers and the total cumulation length.

I want to display in the table.

Description or part number - Material - Length - Width - Thickness - Quantity.

I though that inserting a the column called item quantity would be the answer but this just returns a value of 1.

I have attached the drawing for refernce below.

[BrandonBG]

Post your assembly files and you may get a better answer, but this looks like an instance where you hit a limit in Inventor without using a workaround.

You have item 119 and 120 which are identical, but NOT the same .ipt. The Item Quantity column will always show the number of instances of the part in the assembly. It's not smart enough to know that 119 and 120 are really the same thing.

You already figured out how to group the identical items. For me, the best way would be to create a custom column in the BOM which counts the number of parts in the FOR ITEMS column.

BrandonBG

[Anonymous]

If you can "Pack and Go" the drawing file (or an example file) I can take a look at it when I get the chance. If I'm understanding you correctly there is a way to do what you're wanting, but it is a multi step process and involves a good bit of setup. 

[Vladimir.Ananyev]

I agree with BrandonBG.  A custom column in the BOM a good solution.

Another option is to calculate the items quantity analyzing items list.

Here is the iLogic demo I made to verify this method:

Dim oDoc As DrawingDocument = ThisDrawing.Document
Dim oSheet As Sheet = oDoc.ActiveSheet

'reference to the 1st parts list
Dim oPartsList As PartsList = oSheet.PartsLists.Item(1)
'collection of all rows
Dim oRows As PartsListRows = oPartsList.PartsListRows

For Each oRow As PartsListRow In oRows
    ' the list of items (column 4)
    Dim s As String = oRow.Item(4).Value
    'calculate items quantity analyzing the list
    Dim ss As String() = s.Split(New [Char]() {","c})
    Dim NN as Integer = ss.length
    
    'reference to the target cell (column 9) in the given row
    Dim oCell As PartsListCell = oRow.item(9)
    oCell.Value = CStr(NN)
Next  
'==============

Here is the result:

cheers,

[NachoShaw]

HI

I have a similar process albeit I'm am populating a form table. I use LINQ to group the bom by material then sum the qty rows to give me a qty per material.

Cheers