Community
Inventor Forum
Welcome to Autodesk’s Inventor Forums. Share your knowledge, ask questions, and explore popular Inventor topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

BOM / Parts List Question

6 REPLIES 6
Reply
Message 1 of 7
SteveFrey
918 Views, 6 Replies

BOM / Parts List Question

In my parts lists the length (81 inches) is displayed as 81 in.  How do I make it so it displays as 81 without the "in" suffix?

 

Also, is there a way to enter a formula like in excel so I can divide the sum by 12 then ROUNDUP to the nearest whole number? 

 

Our system is counting the materials we use to the nearest foot and I'd rather export it to excel already converted. 

 

 

Thanks!

Steve

 

Inventor 2012

Steve Frey
Inventor 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
6 REPLIES 6
Message 2 of 7
Cadmanto
in reply to: SteveFrey

Steve,

Edit the parts list and on the QTY column select format column.

 

BOM.JPG

Try editing the units here.

As far as the forumula I really don't know.

Best Regards,
Scott McFadden
(Colossians 3:23-25)


Message 3 of 7
schae235
in reply to: Cadmanto

I am not sure if you would want to do this but there is a formula in ilogic to round a number to the next highest whole number.  I am 98% sure that it is "Ceil()"

 

Not sure if you would want to have an ilogic code to save the parameter using Ceil() and then put that parameter in the BOM?  

 

maybe using

 

 "ThisBOM.OverrideQuantity("Model Data", partNumber,quantity)

 

Example:

 

ftQty=Ceil(inQty/12)

ThisBOM.OverrideQuantity("Model Data", partNumber, ftQty)

Of course  fixing the "Model Data" and the partNumber

INV 2012 SP1
Windows 7 64 Bit
ATI FirePro V5800
14.0 GB RAM
Message 4 of 7
SteveFrey
in reply to: Cadmanto

Thanks!

Steve Frey
Inventor 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 5 of 7
SteveFrey
in reply to: schae235

I haven't used iLogic so I'm afraind this won't work for me.  Thanks.

Steve Frey
Inventor 2021
Windows 10 Professional 64-bit
HP ZBook 17 G6
Processor: Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz
Memory: 80 GB
NVIDIA Quadro RTX5000
3D Connexion SpaceMouse Wireless
Message 6 of 7
Daren.Lawrence
in reply to: SteveFrey

The iLogic approach is a good option but if you’re not comfortable in it there are two other options I can think of: the first is to allow Inventor to round to the nearest whole value – if you don’t care about rounding down. See “Approach_1_A” and “Approach_1_B”.

 

In option 2 you can use the “ceil” function to round up to the next highest integer but it’s expected to be unitless (using ceil) so you need to use isolate;unit;ul like “ceil(isolate(LG;in;ul) / 12 ul)” as pictured. This will make sure that, if the length is 73” it won’t round down to 6’ but round to the next highest foot value (7). Please see the attached images (“Approach_2_A” and “Approach_2_B”).

 

In either case, if you don’t want to show the units, you deselect “units string”.

 

Please mark this as resolved if it answers your questions and resolves this. Thank you. 



Daren Lawrence
Product Support Specialist
MFG Support - Inventor
Autodesk, Inc.


http://beinginventive.typepad.com/being-inventive/
Message 7 of 7

And, due to the 3 attachment limit, here's "Approach_2_B".



Daren Lawrence
Product Support Specialist
MFG Support - Inventor
Autodesk, Inc.


http://beinginventive.typepad.com/being-inventive/

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report