Available in: Logi Info | Source code name: AggregateColumn |
An AggregateColumn 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, Max, or Concat.
The default DataType is "Number". The DataType must be "Number" for the Sum and Average functions. By default, non numeric rows in "Number" columns will be disregarded for function calculations. That is, a data row whose value is "abc" or " " will not be included in the Count function.
Element Group:Add and Replace Columns |