Summary Function Property
Description
Specifies the type of computation function Oracle Forms will perform on the summarized item.
- Avg
The average value (arithmetic mean) of the summarized item over all records
in the block.
- Count
Count of all non-null instances of the summarized item over all records in
the block.
- Max
Maximum value of the summarized item over all records in the block.
- Min
Minimum value of the summarized item over all records in the block.
- Stddev
The standard deviation of the summarized item's values over all records in
the block.
- Sum
Sum of all values of the summarized item over all records in the block.
- Variance
The variance of the summarized item's values over all records in the block.
(Variance is defined as the square of the standard deviation.)
Applies to item
Set Oracle Forms
Required/Optional required (only if associated item's Calculation Mode property is set to Summary)
None
Summary Function Restrictions
You must set the Parameter Data Type property to Number, unless the item's Summary Type is Max or Min, in which case the datatype must mirror that of its associated summarized item. For example, a calculated item that displays the most recent (i.e., maximum) date in the HIRE_DATE column must have a datatype of Date.