---
title: "ACE Analytics Calculating Aggregations"
slug: "ace-analytics-calculating-aggregations"
updated: 2023-04-17T16:22:06Z
published: 2023-04-17T16:22:06Z
canonical: "docs.interprose.com/ace-analytics-calculating-aggregations"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ACE Analytics Calculating Aggregations

The **Aggregate** feature in the Table configuration area, which can be displayed by clicking the Gear icon or by clicking any table column header, lets you calculate totals, averages, and other aggregations:

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/RB_31.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A42%3A18Z&se=2026-10-31T19%3A42%3A18Z&sr=c&sp=r&sig=fYX0Jnz%2FYVN4ScalpXZXc6aZvxauDbr1BLcH6RWdAMY%3D)

Here's how to use this feature:

1. Select the **Data Column** to be aggregated from the column list.
2. Select the **Aggregate Function**. Options include: Sum, Average, Standard Deviation, Count, Distinct Count, Minimum, and Maximum. Click **Add** to aggregate the data and refresh the table.
3. As aggregates are created, they're added to the Aggregates list. Use the adjacent **Replace** and **Remove** buttons to manage the list.
4. Aggregate results appear in an extra table row that can be positioned at the top or bottom of the table, as shown above. If **Grouping** is in effect, aggregate values will also appear at each grouping level in the table.

Generally, columns with Null values are excluded from aggregations. However, your application may be configured to include them; check with the developer of your application for details.

Click the Gear icon to hide the configuration area.