I have an assembly with several virtual components that I'm
using in place of wires (I don't have the routing add-on). In each
of these components I have set the BOM quantity to read from a
custom property "QTY" that is defined as a number, which I'm
planning on using to define the length of wire I'm using. My normal
parts will not have the BOM quantity custom property and appear
correctly in the drawing. My virtual parts show up in the QTY.
column as 1. My goal is to have one column that has the correct
quantity for my normal parts and also the quantity I define for the
virtual part. I have created a new column in my BOM on my drawing
that I would like to use for the listed BOM quantity for both
normal and virtual components.
When I try to define the column with the equation =IF(`QTY`<>"",`QTY`,'QTY.') where `QTY` is the custom property and 'QTY.' is the column property frm the BOM, each cell only shows the equation and not the resulting value. If I do a simple multiplication equation the result is correct. I've also noticed that the column type is changed to a custom property instead of an equation. Is this a bug, or can I not use the IF function in a column equation? Does anyone have a better suggestion on how to approach this problem? Thanks.
When I try to define the column with the equation =IF(`QTY`<>"",`QTY`,'QTY.') where `QTY` is the custom property and 'QTY.' is the column property frm the BOM, each cell only shows the equation and not the resulting value. If I do a simple multiplication equation the result is correct. I've also noticed that the column type is changed to a custom property instead of an equation. Is this a bug, or can I not use the IF function in a column equation? Does anyone have a better suggestion on how to approach this problem? Thanks.
The seperators in an IF statement have to be semicolons. It appears as though you've used commas. If you make those edits, the column should stay as type "Equation" and the values in each cell should populate the way you expected.
I hope this helps,