Insert Formula Column Dialog Box¶
This dialog box groups options for specifying formulas for a column to insert in the extracted data.
Column name
Specifies the name of the formula column. Column names must be unique.
Formula field
Displays the specified formula.
Operator |
Description |
|---|---|
(+) Add |
Adds the value from one column to another |
(-) Subtract |
Subtracts the numerical value from one column from another |
(*) Multiply |
Multiplies the numerical value from one column to another or with a specified value. |
(/) Divide |
Divides the numerical value from one column to another or by a specified value |
Columns
Lists the column names from the extracted data. The list does not include existing formula columns.
Double-click column names to add them to the formula. Alternatively, you can add columns by drag and drop.
To add columns to the formula:
Double-click column names to add them to the formula.
Drag and drop column names to the formula field
Evaluate
Verifies the specified formula. You can use only valid formulas.
Related Topics