BOM Column Equation - Not Working

[brrian]

I want to add a column to my BOM that contains an equation. The equation in plain English:

Logical Test: Is custom property "OverrideQty" is equal to (blank)?
True: Value is equal to column "QTY."
False: Value is equal to custom property "OverrideQty"

The actual equation:

=IF('OverrideQty'="",'QTY.','OverrideQty')

It doesn't work! It shows the equation as a value in each cell of the column. I assume this is because there's an error in the equation (If I put a very simple equation, such as equal to another cell, it works properly).

Is it obvious to any of you what's wrong with the equation? You can probably see what I'm trying to do--I want to set up an 'override quantity' in my parts and reference that in the bom when it is populated.

Help? Thanks!

Brian

 

[CorBlimeyLimey]

Try referencing the actual cell the populated BOM data (OverrideQty & QTY.) is in, not the column heading.

=IF(B2="",C3,B2)


Helpful SW websites faq559-520
How to get answers to your SW questions faq559-1091