How do I calculate the weight of stock within my Routing BOM?

[MattyOstrow338]

Ref: thread561-369635

I am trying to create a Parts list template that calculates the weight of each segment of stock in the parts list. I currently have columns that display the length and weight/ft of the stock, and now I am trying to create another column that reports the calculated weight of that stock, i.e. Length * (weight/ft)

I tried setting the Default Text of the column to <W$=@WEIGHT>*<W$=@LENGTH>, but it doesn't report anything. I've tried doing <W$=@WEIGHT>*<W$=@WEIGHT> and <W$=@LENGTH>*<W$=@LENGTH>, and both of those work and will report the calculated values (with Evaluate Cell as Formula turned on), but not when i try to multiply weight by length.

Is there anyway to get the cells of my parts list to calculate Weight/ft * Length?

Using NX10

Matt Ostrow
CAD Systems Intern | SpaceX

 

[jerry1423]

Can you describe what type of parts these are ? Machined ? Sheet metal ? both or something else?

Jerry J.
UGV5-NX11

 

[MattyOstrow338]

This particular use case is for any sort of Stock applied to routing paths in a routing application (mechanical OR electrical). Tubing, wiring, piping, etc.

My particular use case is just in a test part I made that has four different lengths of tubing stock coming out of a central cross union.

The stock .ptb files have a WEIGHT attribute/column that contains the numerical data for the lbm/ft of each size of stock, which is where the <W$=@WEIGHT> gets its information from, and the <W$=@LENGTH> gets its information from how long the routing path it is applied to is.

The main issue at hand is figuring out why I can't multiply the weight attribute by the length attribute, despite them both being numbers and being able to be multiply them by themselves, as stated in my initial comment.

Matt Ostrow
CAD Systems Intern | SpaceX

 

[jerry1423]

There may be a units problem here.
Make sure the numbers are being multiplied come out to the units that you want, and make sure the resultant expression is set to the proper units.

Jerry J.
UGV5-NX11