Calculations

Add automatic calculations to the footer of your table based on column data. After enabling a calculation, Simple Tables computes results instantly and displays them beneath the table.

Supported calculations

  • Count: total number of rows (including duplicates)
  • Count distinct: total unique values
  • Sum: total sum of numeric values
  • Avg: average of numeric values
  • Max: highest numeric value
  • Min: lowest numeric value

How to add a calculation

  1. Edit the table macro or import dialog.
  2. Open the settings for the target column.
  3. Under Footer calculation, select one of the supported options.
  4. The calculation appears instantly in the table footer.
  5. Click Save to persist it.

Why it matters

Seeing totals, averages or extremes at a glance helps you analyze data faster and confirm correctness—all without exporting or using external tools.

Use case: Budget summary
avatar

Budget Analyst

Acme Co — Finance

Context and challenge:
Finance teams need quick visibility into total spend and distinct cost centers each month. Calculating sums and unique counts in separate tools is tedious, error-prone, and delays budget reviews.

Solution – Built-in aggregations:
The Budget Analyst sets the “Expenses” column aggregation to Sum and the “Units” column to Count distinct. Simple Tables then displays the total expenses and number of unique units in a footer row, updating live as data changes.

Benefits:
• Instant totals: See spend and unit counts at a glance without external formulas.
• Error reduction: Aggregations run on the source data—no manual spreadsheets or copy-paste.
• Real-time updates: Totals adjust automatically when rows are added or edited.
• Streamlined workflow: All budget analysis happens directly in Confluence.

Impact:
By leveraging in-table aggregations, the finance team cut budget-prep time by 60% and improved confidence in monthly forecasts, enabling faster executive decision-making.