cancel
Showing results for
Did you mean:
See all
See all
##### Top groups
Explore all groups

• Global
• Personal

• Give kudos
• Given

• Global

### Kudos (beta program)

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

# It's not the same without you

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

# Is it possible to perform sum calculation in a confluence table?

Hello,

Is it possible to perform a simple sum calculation in a table in confluence?

Is there any plugin that help to do it?

Thanks

Naama

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

Table Enchancer can not calculate.

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

I wish I can down vote.

Hi Sascha! There is a paid app called Excellentable- Spreadsheets for Confluence, where you can perform the SUM formula along with tons of other features. You can try it free for 30 days too! Hope his helps.

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.

Also, there is the Table Transformer macro that can do complex calculations.

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.

I have a table with three columns. Columns A and B have always a value. Column C has only in some rows a value. I want to count the rows, in which column C is empty.

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.

Yes but the result is always a table, although the sum is just one value. Is it possible to get just the sum value in order to put it inline into text paragraph?

Unfortunately, it is not possible to do these tools.

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!

1 vote

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

1 vote

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!

50\$ just for a simple sum?

Sascha,

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

Thanks!

###### TAGS
Community showcase
Posted in Confluence

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

- 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

### Community Events

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

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

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