Edit Formula Column Dialog Box

Displays the equation for the selected formula column.

DATAEXTRACTION (Command) Find: Refine Data (Page 5 of 8) > Right-click over a data cell in a column with a formula > Edit Formula Column

List of Options

The following options are displayed.

Column Name

Specifies a name for the column that can be edited.

Formula

Displays the existing formula or function.

Plus (+)

Adds the numerical data from one column to another.

Minus (-)

Subtracts the numerical data from one column to another.

Multiply (*)

Multiplies the numerical data from one column to another.

Division (/)

Divides the numerical data from one column to another.

Validate

Checks the validity of the specified equation. A formula column can only be inserted when the formula is validated.

Columns

Displays the column names from the extracted drawing data and external data (if data linking was established). Column names can be double-clicked to be added to the Formula field or dragged from the Column list to the Formula field. Existing formula columns are not listed and cannot be used as values for creating additional formula columns.