Testing Conditions to Populate Tables

You can use the logical IF to populate table entries based on a test condition.

In this example, populate a comment column of a BOM with a calculation based on the quantity column value.

  1. Add a new column to the table and label it as necessary.
  2. From the table, click a cell or column heading and for Column type, select Equation.
  3. Click the Equation tool .
  4. For Function click IF.
  5. With the cursor in the parentheses, for Columns, click QTY..
    The Columns lists includes all columns in the table. Selecting items from this list permits calculations based on column values.
  6. Enter strings and column headings to complete the calculation definition so that it reads as follows: IF('QTY.'=1;"Add "'QTY.'+2" more " 'PART NUMBER';"Standard").
    This string tests the values of the quantity column. If the quantity is zero or larger than one, the string Standard is displayed. If the quantity is one, the string Add 3 more parts is displayed.

  7. Click .