Sum fields are used to display the sum of the values of two other data fields, ie. one data field added to the other.

When a Sum field is selected in the field type window, two fields are displayed in the lower half of the window where you should enter the two data fields for which you require the sum. The two data fields will be added together. Each of the fields are selected from a drop down list of all data fields.

Sum fields will automatically be assigned a zero activity number. The two data fields used in the calculation of a Sum field may have any activity number.

At the lowest level of the database, a field set to Sum will display the value of the first data field (Sum1) in the record added to the value of the second data field (Sum2) in the record. At upper levels, a field set to Sum will display the calculated upper level value of the first data field (Sum1) added to the calculated upper level value of the second data field (Sum2).

Wherever a Sum field is used, the component data fields (ie. Sum1 and Sum2) will always be calculated before the Sum field is calculated.