Adding a Calculated Field

Use the Object Properties - Calculation Field to create a simple calculated field. If you need a more advanced calculation, create a Custom Field.

To create a calculated field:

1 Click on the Add toolbar icon, or choose Add Item from the Activities menu. This will display the Object Properties window.

If the Add icon is disabled, it is probably because the report is not in Edit mode. Click the Edit icon to open the report in Edit mode.

2 On the Object Properties window, select $image\radial.gif$ Calculated Field.

3 If the field you're creating is a new column on the report, select þ Add Field To List.

4 Selectþ Include Heading if you want the heading field heading displayed on the report.

5 Heading - Enter a name for the field header.

6 Calculation - Use this section to create a simple calculation.

In the left hand list, select the first field to use in the calculation. Select the operation you wish to do. There is a choice of multiply (x), divide (/), add (+), and subtract (-). In the right hand list, select the second field to use in the calculation.

7 Click Save.

8 Position the field on the report and click the left mouse button.

Advanced Options

When the advanced button is clicked on the Object Properties window the tab will change to display various options. These are:

Remove Cents From Result – Selecting this option will drop the cents from a numeric field. No rounding is involved, the cents are simply lost.

Do Field Filtering After Total – This will force any calculated fields that have a filter on them to only work after a sub-total or grand total has been generated.

Field Justification – This list can be used to specify how the field is displayed on the screen. For example, if centre was selected, the field would be centred within the left and right margins of the field area displayed on the screen.

Number of Export Characters – If the report is to be exported to a file, this can be used to specify that this field will never contain more than this number of characters. This is useful for programs that specify certain fields must be of a certain length.

Position of Field on List – When a field is added to a list it is assigned a number. This number can be changed to move the field left or right in the list.