Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Global
- Personal

- Give kudos
- Received
- Given

- Global

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.

- Community
- Products
- Confluence
- Questions
- Is it possible to perform sum calculation in a confluence table?

To complete Geert's answer:

- Advanced Tables for Confluence (paid): Improves Confluence tables
- Table Enhancer for Confluence (free)
- Spreadsheets for Confluence (paid): Embed spreadsheets
- Play SQL Spreadsheets (paid): Manage data in Confluence

Disclaimer: I'm the author of Play SQL Spreadsheets.

Play SQL can not work with Confluence tables. The data must be stored in a SQL database.

Hello,

There is one more add-on - Table Filter. It has a Pivot Table macro that allows you to make different calculations on a table.

I tried it but this results always in a 2x2 table with 1 value.

Looks pretty ugly. Localization does not work either.

Please, see the docs on how the Pivot Table macro works.

Also, you can add a total row / column to the table using the Table Filter macro.

Or use Table Transformer macro for more complex calculations.

Please, share your use case and I'll recommend the best approach.

Here are some examples:

Count number of rows with not empty Column C:

Count number of rows with empty Column C:

Calculate sum of Column A and Column B in Column C when Column C is not filled with value:

SELECT *,

CASE

WHEN T1.'Column C' IS NULL THEN T1.'Column A' + T1.'Column B'

ELSE T1.'Column C'

END AS 'Column C'

FROM T*

Let me know if any of theses examples suits your needs.

Hello,

In case of CelesteCS Math plug-in you may use the COUNTA function in the following manner:

There are {COUNTA(Table1.C2, Table1.C3, Table1.C4, Table1.C5) } empty cells in the table.

Just add Numerical Expression macro to the page, insert your text insert it and specify the formulas in curly braces. Parameters configuration is described here.

Thanks!

Hi,

There are 2 plugins I know of:

The free one only allows to show a total row. With the paid one you can do more advanced stuff.

Regards,

Geert

Hello, Naama!

For any calculations in Confluence, including any manipulations with table data, you may use CelesteCS Math for Confluence. There are versions for both Confluence Server and Confluence Cloud.

Assume you have a table with three columns and three rows on your page – from A1 till C3, where row 1 is the header row. The sum calculation formula for rows 2 and 3 will be simple:

SUM(Table1.A2:C3)

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.

Thanks!

Sascha,

Not just for SUM. There are hundreds of functions and it really works.

Thanks!

Community showcase ### What do you think is the most *delightful* Confluence feature? Comment for a prize!

Posted in **Confluence**

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

342 views 23 8

Join discussion Connect with like-minded Atlassian users at free events near you!

Find an eventConnect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

- FAQ
- Community guidelines
- Privacy policy
- Terms of use
- © 2020 Atlassian

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.