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.