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,
Edit the parts list and on the QTY column select format column.
Try editing the units here.
As far as the forumula I really don't know.
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
Thanks!
I haven't used iLogic so I'm afraind this won't work for me. Thanks.
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.
And, due to the 3 attachment limit, here's "Approach_2_B".