Working with a Summation User Defined Field
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: