The Function property specifies the computation to be performed on the values of the summary column specified in the Source property. To create running summaries, you place the column in the appropriate group and use the Function propertyin conjunction with the Reset At property.
Applies to |
Summary columns | ||||||||||||||||||||
Values |
| ||||||||||||||||||||
Default |
Sum | ||||||||||||||||||||
Required/Optional |
Required, if column is a summary column. |
Function is only editable when the Type of the column is Summary.
Sum, Average, % of Total, Std. Deviation, and Variance can only be applied to fields with a Datatype of Number.
Reports Builder sets the Datatype for the summary based on the Datatype of the column being summarized.
If the column being summarized is changed, the datatype of the summary changes to match.
A report-level summary cannot have a Function of % of Total. Such a column would make no sense because it would always be 100%.
A column with a Function of % of Total, Sum, or Variance cannot be a break column and cannot have Break Order set.
The Average function will ignore null values in a column (that is, it does not assume a null value equals zero).
Copyright © 1984, 2005, Oracle. All rights reserved.