ds-blue-logo
Preview  |  SOLIDWORKS USER FORUM
Use your SOLIDWORKS ID or 3DEXPERIENCE ID to log in.
FVFilipe Venceslau12/03/2010

Hi people!

I would like to add a column with the total quantity of parts required.

I already have column Qty. which tells me how many parts are in my assembly.

I need a column that will calculate that Qty. times a total assembly quantity.

I have a custom property (of type Number) in my main assembly, which I called "quantity", with the value of 3.

I've tried entering the following equation:      'QTY.' * $PRPSHEET:"quantity"

Which returns me a value of:                      ='QTY.' * 3

If I replace $PRPSHEET:"quantity" with an actual number, I do get a calculation, but anytime i refer to a custom property (even of the parts) it doesn't seem to want to calculate the value.

My conclusion is that this value is being brought over in a string format, and BOM isn't capable of recognizing it as a number, so it doesn't calculate it.

I've discussed this with solidworks support, and no one was able to give me a straight answer.

Anyone out there ever run into this problem? Any work around?

I've also tries referencing to a custom property in the drawing itself, but I always run into this problem.

Thanks!!