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.
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?
Please try the following:
To set “precision” in a BOM table, you will need to use equation as your column
The syntax is
{precision}1*'CustomProperty/Column'
For example:
{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
@“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:
- Create a column, link it to Weight Custom Property, name the column something else (eg: DummyW)
- Create another column, name it Weight, use the equation discussed above to set the precision while linking to the column created in step one
{2}1*'DummyW'
- 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
Hoping this thread still finds you.
Using an equation makes the BOM do exactly what I want (display 3 place decimal).
I’m trying to save this out as a template but I have some issues:
- when I save out the BOM as a template, the formulas do not save with the BOM template.
- how can I specify absolute value on a cell.
