Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Parts variables and assembly variable multiplication in BOM

ABHUT_9090
Enthusiast

Parts variables and assembly variable multiplication in BOM

ABHUT_9090
Enthusiast
Enthusiast

Hello,

In the BOM , I want multiplication of column1 (lengths of parts) and column2 (Item qty of that pats) in another column3( total length required ). Can anybody help me with the ilogic code for this?  Main problem is how can we multiply this two column and get output in third column.

 

Thank you

 

Ankit Bhut

0 Likes
Reply
1,396 Views
20 Replies
Replies (20)

WCrihfield
Mentor
Mentor

I agree with the statements hat @pcrawley mentioned in that other thread.  It is pretty much always a bad idea to store assembly level data, especially BOM type data, back down to part level.  One of the reasons is that the part may be used in multiple other assemblies and that data may be different within those other assemblies.  If the data from one assembly is written down into the part, then later similar (but different) data from another assembly overwrites that data within the part, then the information shown in the first assembly is going to be wrong, if its is being sourced from the data written within that part.

 

In Inventor 2022 we are given the ability to store data within what are called "instance properties", which are like custom iProperties that will only exist for component instances within the context of an assembly.  And I believe you can show a column in the assembly BOM view that will display the value of a common component instance property.  I don't know if that would help you out in this situation or not, but at least the data would be kept at assembly level, instead of being written down to the part documents.

 

There are at least 2 main ways that folks often deal with situations like this.  One of the most common options is to just add the wanted additional column within the drawing document's PartsList, instead of trying to do it within the assembly document's BOM.  Working with the PartsList is a lot more user friendly and you have access to all the rows, columns, and cells within them.  Another course of action is when the BOM is exported to Excel (for whatever purpose).  After they export the BOM to an Excel speadsheet, they can then create the extra column(s) they want, and fill in the cells the way they want, possibly even using an equation within the cell.  This Excel interaction can either be done manually, or sometimes can be automated by code.

Wesley Crihfield

EESignature

(Not an Autodesk Employee)