Hi everyone, I am new here. I would like to know if it is possible to perform calculations in Confluence tables. For example: * Column A = Price * Column B = Taxes (%) * I would like to automatically calculate Price × Taxes and show the result in a new column. Is there a native feature in Confluence to do this, or would I need to use an add-on or macro? Thanks a lot for your help!

Hi @Mark Pliacnik and welcome to the community. As @Brita Moorus already mentioned, native Confluence tables/Databases don’t support computed columns yet; there’s an open Atlassian suggestion for formulas in Databases. If you need Price × Taxes per row today, this is straightforward with Simple Tables app for Confluence: * Wrap your existing Confluence table with the Simple Table (bodied) macro to enable features. * Add a Calculated column and set the formula to =price * taxes, then name the column Total. (Optional) If you’d like a grand total, turn on a Sum in the footer for that column. Hope this helps! — Mia Tamm

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to calculate values in Confluence tables based on other columns (e.g. price × taxes)?

Mark Pliacnik

Hi everyone, I am new here. I would like to know if it is possible to perform calculations in Confluence tables. For example:

Column A = Price
Column B = Taxes (%)
I would like to automatically calculate Price × Taxes and show the result in a new column.

Is there a native feature in Confluence to do this, or would I need to use an add-on or macro?

Thanks a lot for your help!

Accepted answers

Brita Moorus

Hi! 👋 Welcome to the community!

Confluence tables and Databases don't yet support automatic calculations or computed columns. There's an open suggestion for it here: CONFCLOUD-78459.

In the meantime, a few Marketplace apps can help, like Table Filter, Charts & Spreadsheets for Confluence, Elements Spreadsheet, or Excel-like Tables for Confluence - all great options if you need live formulas and summaries💡

Hope this helps! ☀️

Mia Tamm _Simpleasyty_

Hi @Mark Pliacnik and welcome to the community.

As @Brita Moorus already mentioned, native Confluence tables/Databases don’t support computed columns yet; there’s an open Atlassian suggestion for formulas in Databases.

If you need Price × Taxes per row today, this is straightforward with Simple Tables app for Confluence:

Wrap your existing Confluence table with the Simple Table (bodied) macro to enable features.
Add a Calculated column and set the formula to =price * taxes, then name the column Total.

(Optional) If you’d like a grand total, turn on a Sum in the footer for that column.

Hope this helps!

— Mia Tamm

All comments

Brita Moorus

Hi! 👋 Welcome to the community!

Confluence tables and Databases don't yet support automatic calculations or computed columns. There's an open suggestion for it here: CONFCLOUD-78459.

Hope this helps! ☀️

Mia Tamm _Simpleasyty_

Hi @Mark Pliacnik and welcome to the community.

As @Brita Moorus already mentioned, native Confluence tables/Databases don’t support computed columns yet; there’s an open Atlassian suggestion for formulas in Databases.

If you need Price × Taxes per row today, this is straightforward with Simple Tables app for Confluence:

Wrap your existing Confluence table with the Simple Table (bodied) macro to enable features.
Add a Calculated column and set the formula to =price * taxes, then name the column Total.

(Optional) If you’d like a grand total, turn on a Sum in the footer for that column.

Hope this helps!

— Mia Tamm

Stiltsoft support

Hi @Mark Pliacnik ,

Indeed our Table Filter, Charts & Spreadsheets for Confluence app that was kindly mentioned by @Brita Moorus can help your case.

If you prefer to work with native tables and perform calculations there, you may take the Table Transformer macro.

If you want to work with Excel-like sheets and familiar cell formulas, you may use the Table Spreadsheet macro.

Please book a call with our team - you'll be able to share more use cases and we'll be able to guide you through them live.

Victor Law - Ricksoft

Thanks, @Brita Moorus, for recommending Excel-like Tables for Confluence as one of the potential solutions.

Hi @Mark Pliacnik

Welcome to the community!

Performing calculations based on another table isn’t currently supported by Confluence’s native table functionality yet.

However, this can be achieved using the Excel-like Tables for Confluence app. It should be relatively easy for the team to adopt, as it functions similarly to Excel.

Here’s a quick demo showing how it can be done:

Additionally, you can utilize the cell linking feature to display live data from different spreadsheets.

Thank you.

Mark Pliacnik

Hi everyone,

Thank you all for the warm welcome and for taking the time to share suggestions 🙏

@Brita Moorus – I really appreciate the range of options you suggested. It’s very helpful to see the different possibilities that exist, and it gives me a clearer view of what can be achieved in Confluence.

@Stiltsoft support – Thanks a lot for the detailed explanation of your macros. They certainly cover many advanced scenarios. For my case though, the app feels a bit too complex and not very intuitive for the simple calculations I’m trying to achieve. Out of curiosity, is your app ROA or do you have plans to make it ROA in the future? That could make it easier to adopt.

@Victor Law - Ricksoft – Thank you for sharing the demo of Excel-like Tables, it was very clear. However, I’d prefer not to go with an Excel-based approach. I mainly work with native Confluence tables and would like to keep the solution within that context.

Overall, I really value all the advice shared here. Even if I take a slightly different path, your feedback has helped me understand the landscape much better.

Thanks again!
Mark

Mark Pliacnik

Hi @Mia Tamm _Simpleasyty_

Thank you so much for sharing this! I didn’t know about the Simple Tables app, and I have to say it really surprised me in the best way — the approach you suggested looks very straightforward and exactly the kind of simple solution I was hoping for.

I especially like how easy it is to apply the steps you outlined without overcomplicating things. Really appreciate your help here.

Mark

Anatolii Starshekov _Wombats Corp_

Hi, @Mark Pliacnik

As you've mentioned that there's no need for complex macros, you may want to try customizable user macros.

In a nutshell, you can keep it simple or add more features as you wish.

I've tested the app, created a template and used it in a page.

Please check it out. Is that the thing you meant?

ScreenRecording2026-02-04at13.30.01-ezgif.com-video-to-gif-converter.gif

Alex james

Confluence’s standard tables don’t currently provide reusable per-row formulas such as multiplying two columns. You’d generally need an add-on or another spreadsheet-style solution for that.

For example, with the right table tool, a formula like =Price * Taxes could automatically calculate the value for each row. A feel free to calculate approach like this can make recurring calculations much easier to manage.

CelesteCS

Hi, I'm with CelesteCS - we make Math for Confluence Cloud, which handles exactly this kind of per-row calculation.
With the Numerical Expression Cloud macro placed in your third column's cells, a per-row formula referencing the other two columns in the same row is just:

Table1.B2*Table1.C2

for row 2, Table1.B3*Table1.C3 for row 3, and so on - each cell recalculates live whenever the page is
viewed, so if you edit the price or tax rate later, the total updates itself. If you'd rather express the tax as a percentage: Table1.B2*(1+Table1.C2/100).
Quick start: https://celestecs.com/support/documentation/math/how-to-start

Support_Kenputer

Hi Mark,

A standard Confluence table does not calculate one cell from other cells on its own. For your example, you would need an app or macro to keep the native table and calculate Price × Taxes in a new column (for example, with an Excel-style formula such as =A2*B2).

Qron Calc Macro is one option: it supports Excel-style formulas in native Confluence tables, including SUM, AVERAGE, IF and VLOOKUP. Results recalculate when values change, including while editing/live docs, and are included in Confluence PDF export. It is free for up to 10 users, but it is not a full spreadsheet canvas (no pivots or workbook UI).

Marketplace: https://marketplace.atlassian.com/apps/1217478/qron-calc-macro-excel-formula-in-table?hosting=cloud
User guide: https://documents.test-perspective.com/qron-calc-macro-for-confluence-cloud/guide-for-users/

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table

table-filter

table-filter-and-charts

calculation

table-transformer

table-spreadsheet

table-filter-charts-spreadsheets