Create Calculated Field
Description
Creates a new column based on a calculation.
Follow these steps to create a calculated field:

Right+Click on a numeric field and select Compute > Create Calculated Field from the context menu. The Create Calculated Field dialog displays:

Define the calculated field by selecting the calculation components. You can include columns, numbers, and operators:

Note that:

Only numeric fields are included in the columns list.

As you define the formula a sample of the output is displayed in the preview area at the bottom of the dialog box.

Select Enter to add the calculation as a new column.

Rename the column.
INPUT/Output DATA TYPE
Input 
numeric 
Output 
numeric 
example
In this example, the first column (Amount) is the original column. Discount is a calculated field that shows the 10% discount value. It uses the following simple formula: Amount * .10: