AnsweredAssumed Answered

Total quantity equation

Question asked by Filipe Venceslau on Mar 12, 2010
Latest reply on May 7, 2010 by Filipe Venceslau

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!!

Outcomes