Modifying Device Designs › Editing Report Designs › Example 1: Simple Report Design › Function Fields

Function Fields

You can also add to the report device design a total count of the number of machines on each format. To do this, you use the function fields as follows:

1. Define a function field Total Number of Machines of the type SUM, based on the No of Machines field.
2. Add this field to the Area, Country, and Final Total formats accepting the default parameters.

To add the function fields to accumulate the number of customers you can:

1. Define a CNT function field, Count No. of Customers, with Customer Code field as the input parameter.
2. Add the CNT field to the Area Total Format.
3. Define a SUM function field, Total of customers, based on the Count No. of Customers field.
4. Add the SUM field to the Country and Final Total formats, accepting the default parameters.