Multiple Conditions in BOMs

Hi,

I'm looking for a way to add a condition or expressions in the BOM QTY. column that

can read two different values from two different parts.

  1. In the model called glue the required value = AR
  2. In the model called Deleted the required value = 0

I need the BOM to overwrite the QTY. column and show AR for AR & be Blanked for 0 value.

see attached image.

SolidworksBill Of Materials