How to calculate totals in a Confluence table
Simple Tables can calculate summary values in the table footer or within grouped sections, depending on whether you need one overall result or a result per category.
Choose the aggregation
Use sum for additive values, average for a representative mean, count for populated records, and minimum or maximum for range boundaries.
Configure footer totals
Edit the table, open the column aggregation settings, choose the numeric column and aggregation, and enable the footer result. Verify that the column is configured as a number.
- Set the column type
- Choose the footer aggregation
- Select its display mode
- Test empty and zero values
Calculate totals by group
Group by a category such as team or region and apply an aggregation to the value column. This produces a result for each group rather than only one table-wide total.
Related Simple Tables documentation
Frequently asked questions
Why is a total not calculated?
The column may be configured as text or may contain values that cannot be interpreted as numbers.
Can Simple Tables calculate an average?
Yes. Average is supported for both documented aggregation and expression workflows.