Available in: Logi Info | Source code name: SqlAggregateColumn |
ActiveSQL SqlAggregateColumn adds a new column in the DataLayer that represents an aggregate value of all rows of the DataLayer.
The column can be used like any other column. The value is populated in every row so that it can be used in further calculations, SummaryRows, LinkParams, etc. It is also populated in the top-level row, allowing reference to the value anywhere in the report outside of a DataTable.
Set the ID to the name of the new column.
Set the AggregateFunction attribute to the type of aggregate desired, Sum, Count, Average, Min, or Max.
The column data type must be numeric for the Sum, Count, and Average functions.
Element Group:Add and Replace Columns |