I created a part and made a custom property called BulkQty as
text and entered 3 OZ as the value and inserted the part into an
assembly file. I then created a drawing with the assembly and
inserted a BOM with a column for the BulkQty. I tried to write a
formula in another column " =(`BulkQty`)" but it doesn't seem to
read the BulkQty column. I then put the row/column address of E9
but it only reads the number 3 but not the text "OZ." I would
eventually like to have it read the value of BulkQty is if it is
greater than zero otherwise use the value of the QTY. column. From
what I have read I thought something like " =If(#`BulkQty` > 0 ;
'QTY.";`BulkQty`)" would work but I am nowhere close to working
this one out. Can anyone help?

Thanks

Dan Miel

2008

Thanks

Dan Miel

2008

I was putting the equation in a single cell. When I put your equation in a single cell it did not work but when I entered your equation in for the whole column it seems to be working. I think at some point I had tried the same equation before but entering it as a column equation instead of a cell equation may have been the trick.

Thanks Dale

Dan