Table Equation Editor

You can use the equation editor to include calculated quantities or simple logic in a table or BOM cell, or in a BOM column.

Equations in cells or columns are indicated with an equation symbol.

To open the equation editor from a table or BOM cell:
  1. Select a cell.
  2. Click Equation (Table format toolbar).

To open the equation editor from a BOM column:
  1. Double-click the top of a BOM column, just above the column heading.
  2. Select Equation from the Column type list, and click Equation .

Using the Equation Editor

To use the equation editor:

  1. Select a mathematical or logical operator from the Functions list.
  2. Select table cells on which to operate and save the equation.
When creating equations for tables, you can:
  • Type the argument for an operator between parentheses.
  • Select a custom property on which to operate from the Custom Properties list.
  • Click cell values (such as B3 or A1) to use in an equation. For example, B3*.08.
  • For columns of BOM tables only, select the column on which to operate from the Columns list.
  • Select a precision for numerical calculations from the Precision list.
    Precision must precede the equation. For example, to set the precision to 2 decimal places for the product of cell A1 and .75, use {2}A1*.75.

Example Equation

You can calculate the total of the items in a BOM column and display this value in another BOM table cell.

  1. Select a blank table cell in the BOM and open the equation editor.
  2. Type or select SUM from the Functions list.
  3. Type the BOM column or cells to total. For example, to find the sum of the items in a column:
    1. Click the first item in the column.
    2. Type :.
    3. Click the last item in the column.
    The equation code appears in the equation text area.
  4. Click .