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.