Skip to content

Language Constants - Summary Types

The following constants can be used in a SUM() function.

Constant Explanation
drAverage Calculate the average of the values of the field used in the summary operation. Only available on numeric field types.
drCount Count the number of times the field has been printed. Can be used on any field type.
drDistinctCount Count the unique values out of the values in this field.
drMaximum Determine the maximum value out of the values of the field used in the summary operation. Only available on numeric field types.
drMedian Calculates the median or 'middle' value of the field. If the number of values is even, the average of the middle two values is calculated. Only available on numeric field types.
drMinimum Determine the minimum value out of the values of the field used in the summary operation. Only available on numeric field types.
drSum Sum the values of the field used in the summary operation. Only available on numeric field types.