Formula inside Parts List cell

[nelani]

I'm using NX Routing Electrical tool and have assigned WEIGHT per unit length attribute(characteristic) for the wire stock data in the .ptb file. While generating BOM, i'm trying to calculate the Weight for the wire by setting <W$=@WEIGHT>*<W$=@length> as Default text inside a BOM Column.Also, i've enabled "Evaluate cell as Formula" option. But it doesn't seem to work.Please suggest a solution.

 

[JohnRBaker]

When you use those schemes to get the weight and length of items, the results are 'strings' not numerical values. You can't multiply two strings as if they were two numbers.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

 

[nelani]

Hi John,
Thanks for replying. But i tried <W$=@length>*<W$=@length> and it works. i.e., it returns a number. Also, i set two number attributes var1 & var2 to a component and in the part list tried <W$=@var1>*<W$=@var2> and it returns the product.So, I think it doesn't work only for the wire stock components.Sorry if i'm wrong....
As you said, if strings are returned, is there any function to convert it to a numeric value inside parts list....

 

[JohnRBaker]

It might just be the weight value since that is not based on reading the numerical value of an expression nor an attribute which has been explicitly declared as being a number.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.