topic Re: BOM (Assembly) columns multiplication in Inventor Programming Forum

BOM (Assembly) columns multiplication

ABHUT_9090 — Tue, 31 May 2022 12:51:43 GMT

Hello everyone,

I need to multiply item qty and SQ_INCH column to get TOTAL_SQ_INCH. I need help with ilogic code to get this output.

Thank you.

Re: BOM (Assembly) columns multiplication

SBix26 — Tue, 31 May 2022 15:16:13 GMT

Inventor iLogic, API & VBA Forum

Sam B

Inventor Pro 2023.0.1 | Windows 10 Home 21H2

Re: BOM (Assembly) columns multiplication

johnsonshiue — Wed, 01 Jun 2022 00:02:27 GMT

Hi! Sam is right. This requires an iLogic rule. The way BOM handles property expression is purely text-based. IT does not involve any math.

Please take a look at an old thread. The expert users share some apps and an iLogic rule.

https://forums.autodesk.com/t5/inventor-forum/part-assembly-quantities/td-p/4342976

Many thanks!

Re: BOM (Assembly) columns multiplication

pcrawley — Wed, 01 Jun 2022 02:16:41 GMT

It is achievable with iLogic, but the result would be so dangerous I'd strongly recommend not doing it.

If you calculate the TOTAL_SQ_INCH value based on the three instances of that part in the assembly, then push it to the part's iProperty, the result would be correct.

In the next assembly you place four instances of the same part. One of two BAD things will now happen:

You'll forget to run the iLogic and the the BOM shows TOTAL_SQ_INCH for 3 instances - which is incorrect because you placed 4 instances.
You'll remember to run the iLogic rule and update the TOTAL_SQ_INCH for 4 instances. You just invalidated the first assembly which had 3 instances.

I would suggest doing calculations like that in the Parts List on the drawing using substitution & sum of values.