how can I create a table with calculations

[Mathijs Groen]

This question is in reference to Atlassian Documentation: Table of Contents Macro

Hi, I have a table created in Excel, with contains calculation on rows / columns (simple calculation like adding numbers).

I want to create same table in Confluence. So including the calculations so that table is updated if the numbers change. 

I have looked at Macros -> Other Macros -> Table Plus but this table doesnt allow me to calculate on rows (right?).

It would be perfect if I could import the Excel table into Confluence and the markup and calculations would remain. 

Is this (or something similar) possible in Confluence? If so, how to do it?

[cirosantilli]

Possible duplicate of: https://community.atlassian.com/t5/Questions/Is-it-possible-to-perform-sum-calculation-in-a-confluence-table/qaq-p/189923

[CelesteCS]

Hello!

For any calculations in Confluence, including calculations over tables, you may use CelesteCS Math for Confluence. There are versions for both Confluence Server and Confluence Cloud.

Assume you have a table with three rows and four columns: A till D with two rows and want to summarize elements from B2 to D2. Then here is the formula you should specify in A2:

SUM(Table1.B2:D2)

If you want to calculate average value, use AVG function:

AVG(Table1.B2:D2)

As you see, it is very simple and is similar to EXCEL with equal set of functions.

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

Thanks!

[Abyakta Lenka]

your site is not working to see the documentation .

can you please check.

[CelesteCS]

Hi Abyakta,

Here is a direct link to the documentation page: http://celestecs.com/support/documentation/math. Can you open it? What is shown?

Thanks!

[Chad Corman]

Alexey - I get a timeout when trying to access your site.  Can you please advise when it is back on line?

[CelesteCS]

Hi Chad!

It should work now.

Thanks!

[Andrey Khaneev _StiltSoft_]

Hi Mathijs,

You can try Pivot Table macro from Table Filter and Charts add-on.