A Summation user defined field (UDF) is a
Permanent Information field available for use in a data grid, form, report, or as a filter in scheduling. It is a simple yet powerful UDF that provides useful information when analyzing pipeline data.
The function of a Summation UDF is to aggregate data for a target field using one of the following operators:
Average,
Count,
Latest,
Maximum,
Minimum, and
Sum. As an option, you can also include one or more filters that run either before or after the data aggregation.
Example: Set up a Summation UDF using
Structure P/S as the target field and
Average as the operator. Include a
Calculated UDF as a filter in the
Summation UDF that is set up to find the variance between the actual and average
Structure P/S reading for test points. The expression for the
Calculated UDF is
ABS([My Summation Name] – [Structure P/S]). Add the
Summation and
Calculated UDFs in the
Test Point Inspection data grid to view the results of the data aggregation. For more information about working with a
Calculated UDF, refer to
Adding a Calculated User Defined Field.
Information in this section explains how to work with a Summation user defined field. Topics include those in the following list: