Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. To use a field or column in a function, on a joined table in the Report Designer panel, click  and then click Aggregate.
    Image Added
  2. The type of aggregation possible depends on the data type of the field. In the Aggregate Functions pane, click the down arrow on Report Designer panel, click Image Added to the right of the field name and select one of the following:
    • Avg: The average of all non-null values in the column
    • Count: The count of all non-null values in the column
    • Max: The maximum of all non-null values in the column
    • Min: The minimum of all non-null values in the column
    • Sum: The sum of all values in the column