Is it possible to perform sum calculation in a confluence table without using any plugin

[infotech]

Hello, 

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

Thanks

Sudheer

[Katerina Kovriga {Stiltsoft}]

Hi there,

As this Community thread mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view and edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Stiltsoft support]

An update: please check out two additions to our spreadsheet family - Spreadsheet from Table and Table Spreadsheet Include macros.

The first one turns manually created and macro generated (Jira Issues, Page Properties Report) tables into fully functional Excel-like spreadsheet. The second one - helps to reuse parts of your sheets across your Confluence instance.

Hope you may find it useful.

[Tim Oldendorf]

This might work for you

https://marketplace.atlassian.com/apps/1218080/xtables?hosting=server&tab=overview

[infotech]

okay. Is any free addon there?

[Andrey Khaneev _StiltSoft_]

Hello Sudheer,

Yes it is possible with the help of add-ons. Table Filter macro provides you with an ability to calculate sum for rows and columns, also there is a Pivot Table macro for calculating sum against some unique values in the table.

[Andrey Khaneev _StiltSoft_]

Yes, you can create your own user macro or write javascript and add it to the page using HTML macro.

[infotech]

Hi Andrey,

Thank you.. Is it possible with out the help of add-ons.

[Lava Kumar Dukanam {Appfire}]

Hi there,

There are a couple of solutions here in the following discussions.

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

https://community.atlassian.com/t5/Confluence-questions/Is-it-possible-to-perform-sum-calculation-in-a-confluence-table/qaq-p/189923

Hope it helps!

Thanks,

Lava

[infotech]

Is it possible through help of the any code(like scripting)

[Andrey Khaneev _StiltSoft_]

Unfortunately, there is no such built-in tool in Confluence.