Page 1 of 1

Control of decimal places in BOM

Posted: Wed Jun 16, 2021 8:15 pm
by mrlegoman
I have an intendent BOM. Top level assemblies are set to zero places, sub-1000 lb asm's set to 1 dec place. Piece parts are set to 2. Yet some of the parts are stuck at zero decimal places.
sw4.jpg
I've looked at print properties, part properties, BOM properties. Driving me nuts. I went through everything and re-set it all to 1 dec place and a couple of these still show up at 0 dec places. Is there a setting possibly in materials? And I missing something simple or is SW just still dumb with BOM's?

Re: Control of decimal places in BOM

Posted: Thu Jun 17, 2021 5:07 am
by zwei
Please try the following:

To set "precision" in a BOM table, you will need to use equation as your column
The syntax is

Code: Select all

{precision}1*'CustomProperty/Column'
For example:

Code: Select all

{2}1*'Qty'
image.png

Note:
You will need to multiple your custom property / column by 1 in order for integer to show with decimal place...
I believe this is something related to how SOLIDWORKS treat number, multiplying the integer by 1 will somehow force it to become a floating number that can have decimal

Re: Control of decimal places in BOM

Posted: Thu Jun 17, 2021 10:46 am
by mrlegoman
@"Zhen-Wei Tee"
So close! I setup your equation with our "WEIGHT" properties, but it brings in the mass of the top level assembly called out in the print instead of the specific part mass for that row. Going to work with the equation some more.

Re: Control of decimal places in BOM

Posted: Thu Jun 17, 2021 11:12 am
by zwei
mrlegoman wrote: Thu Jun 17, 2021 10:46 am @"Zhen-Wei Tee"
So close! I setup your equation with our "WEIGHT" properties, but it brings in the mass of the top level assembly called out in the print instead of the specific part mass for that row. Going to work with the equation some more.
I believe you can try the following:

1. Create a column, link it to Weight Custom Property, name the column something else (eg: DummyW)
2. Create another column, name it Weight, use the equation discussed above to set the precision while linking to the column created in step one

Code: Select all

{2}1*'DummyW'
3. Hide the column create in step one

The idea is that the "Dummy" column will pull in all the Weight custom property of the part while the Weight equation column will set the precision
image.png
image.png (3.98 KiB) Viewed 4351 times