How can I sum CAD transaction values directly inside a table in Confluence?

[Evelyn Sharpe]

Hi everyone, I'm new to the Community 😊

I have a list of transactions (in CAD – Canadian Dollars) that I’d like to manage directly inside Confluence without having to rely on Excel or Google Sheets. Is there a way to import this data into a table and automatically calculate the total amount (and maybe other aggregations like averages) directly on the page? I’d love to keep everything inside Confluence if possible.

Cheers,
Ev

[Mia Tamm _Simpleasyty_]

Hey @Evelyn Sharpe, welcome to the Community! 👋😊

If you’re looking to manage your CAD transactions directly inside Confluence without jumping in and out of Excel or Google Sheets, you might want to try the Simple Table with Body macro (from our app Simple Tables for Confluence).

With it you can:

• Add your table from Confluence

• Display your CAD values in a column

• And automatically calculate the total sum (plus average, min, max, count…) using built-in footer aggregations — all without leaving the page

I actually recorded a quick Loom showing this exact setup — happy to post it here if that would be helpful for you? 😊

— Mia Tamm from Simpleasyty

[Tomislav Tobijas]

Hey @Evelyn Sharpe ,

Firstly—welcome to the Community! 👋

Regarding the question > while Confluence native tables do not support aggregations, you could maybe use Confluence Databases, which is also native Confluence functionality (a bit different than a page itself).

Anyway, databases support sums and averages for number columns (+ number columns can be set as currencies, although the Canadian Dollar is not yet supported).

Additionally, once you create a database, you could embed the view in the Confluence page to get a table-like representation.

Here's a short lesson in Atlassian Learning to get quickly onboarded with databases: Create databases in Confluence 

Cheers,
Tobi