Complete the following steps to create a formula field:
In an open template or report, click Tools > Formulas Editor.
Click New.
Use the Specify Formula window to define the formula:
Enter the Name of the new field.
Add a Description of the field. This description is displayed when you select the field in the Add New Field window, and it is displayed in the field's tool tip.
Select the Entity for the formula. The list of available data fields is based on the selected entity.
In the Formula field, define the data field's formula. A formula is a combination of predefined statistical data that appear in existing fields. The Specify Formula window provides options to make it easy for you to define a formula. Select the field data for the formula from the Column list. Use the mathematical operators to specify the action to be taken.
Specify the Formula Type. This ensures that the correct internal operators are used to format the formula, so that you get the expected result.
Click Verify to test that the formula is valid.
Click Save to save the formula field under its current name. If you want to same the formula field under a different name, click Save As. To include the new formula field in a template or report, you must add the field. Refer to Working with Fields.