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

[Naama Lev]

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

[Adrien Ragot 2]

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.

[Sascha Ziemann]

Table Enchancer can not calculate.

[Sascha Ziemann]

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

[Sascha Ziemann]

I wish I can down vote.

[Jaclyn Mazzarella]

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. 

[Andrey Khaneev _StiltSoft_]

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.

[Andrey Khaneev _StiltSoft_]

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

[Sascha Ziemann]

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

Looks pretty ugly. Localization does not work either.

[Andrey Khaneev _StiltSoft_]

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.

[Sascha Ziemann]

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.

[Andrey Khaneev _StiltSoft_]

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.

[Sascha Ziemann]

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?

[Andrey Khaneev _StiltSoft_]

Unfortunately, it is not possible to do these tools.

[CelesteCS]

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!

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Sascha Ziemann, 

We've released the improvement that allows you to get a single value from Pivot Table as an inline text. Please update the app and use the Show result as plain text option.



Katerina
Stiltsoft

[CelesteCS]

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 Ziemann]

50$ just for a simple sum?

[CelesteCS]

Sascha,

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

Thanks!

[Geert Graat]

Hi,

There are 2 plugins I know of:

• Advanced Tables for Confluence (paid)
• Table Enhancer for Confluence (free)

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

Regards,

Geert

[cirosantilli]

Possible duplicate of: https://community.atlassian.com/t5/Answers-Developer-Questions/Calculation-in-tables/qaq-p/570820