Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

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

View group

It's not the same without you

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

Atlassian Community Hero Image Collage

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

 

5 answers

To complete Geert's answer:

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.

2020-05-26 15_26_49-306_20_15 - Referenzumgebung - K3LS Documentation.png

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.

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:

2020-05-27_17h06_12.png

Count number of rows with empty Column C:

2020-05-27_17h07_48.png2020-05-27_17h08_56.png

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

2020-05-27_17h14_28.png

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!

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!

50$ just for a simple sum?

Sascha,

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

Thanks!

Suggest an answer

Log in or Sign up to answer
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
Join discussion

Community Events

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

Find an event

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

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

Host an event

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

Events near you