Report Functions › Introduction to the Print File Function › Defining New Function Fields

Defining New Function Fields

The first new function field, Total horse value, will provide a total of all the Horse value fields on the detail format. A function field of type SUM is used for this purpose. Recall that you used a function field of this type previously to calculate the Total Number of finishers in a race.

The second new function field, Total number of horses, will calculate the total number of horses recorded. It will count the number of occurrences of Horse code field on the detail format. A function field of type CNT can be used for this purpose.

There are two ways to define a function field:

• As a REF field based on the field you wish to sum or count
• As a new field with input parameter(s) specified separately.

You will use the REF field method to define the Total horse value function field. However, you cannot use this method for the Total number of horses function field since the CNT field must be numeric and the field you are counting is alphanumeric (CDE).

Define the Total horse value and Total number of horses function fields.

Press Enter.