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!

[Mia Tamm _Simpleasyty_ · Accepted solution]

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:

1. Wrap your existing Confluence table with the Simple Table (bodied) macro to enable features.
2. 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

[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

[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! ☀️

[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

[Stiltsoft support]

Hey @Mark Pliacnik ,

The standard calculations (totals, averages, min and max) can be done in one click using the Table Filter macro that makes all your tables filterable. Aggregation (grouping) can be done via user-friendly UI using the Pivot Table macro (similar to pivot tables in Excel).

And other calculations can be performed via the Table Transformer macro and SQL syntax, for your case it's very simple and intuitive:

SELECT
T1.'Item',
T1.'Price',
T1.'Tax (%)',
ROUND(T1.'Price' * (1 + T1.'Tax (%)' / 100), 2) AS 'Price with Tax'
FROM T1

What concerns ROA: we are currently transferring our macros to Forge and plan to finish in December. After that we should get the badge: https://docs.stiltsoft.com/tfac/cloud/faq-security-71860350.html#FAQSecurity-DoestheapprunonForge?