Solidworks

Hi All,
I have a baffling issue with one of our BOM templates (created before my time in this company). There is a column in the template which has an equation to give total weight of a component in an assembly. This basically multiplies the no.of instances of the component with its unit weight to give total weight of the component. below is the actual equation
={1}Weight*‘Qty.’
This was working fine until around 5/20 and nothing changed in the BOM template (it is in PDM and history shows no changes done). But now if weight is manually entered in a part’s custom property (instead of using swmass or other property link) this column shows zero for the BOM in the drawing for the assembly. The only way to fix this is by changing the weight custom property to number from text in the part file. But this has always been in text and still the equation used to work without issues. This has broken several files across our vault and we dont know what caused the issue.

I tried several things including creating a new BOM from scratch and I get the same results. I also called our VAR TS and their response was something like a windows update could have broken this. Any insight is much appreciated.
I have attached images of working and broken weights and a copy of the newly created BOM template as well.

Could someone test in Solidworks 2023 SP3 version if possible. Any insight is much appreciated.
New_STD bom template.zip (4.97 KB)
working.jpg

I am told by a user who has encountered what I believe is this same issue, that you need to be careful about the character ` vs ’ in the equation string:

={1}Weight*‘Qty.’

Perhaps try making it:

={1}‘Weight’*‘Qty.’

I am also running into something similar.

I would like my BOM to read the Bounding Box properties for each component and read out a 3 plc decimal.

The Decimal place I have solve (use a formula) but I have 2 other problem:

  • When I save the BOM as a template the formulas do not save.
  • How do I add an absolute value to the cell OR How do I have it read the parts Bounding Box for that part/row?