Calculations/formulas in confluence page that changes dynamically

[Team Awesome BVBA]

Hellow,

I have a report with this tables:

"Defects total / defects ok / defects nok / % defects ok"

I would like to have the % in the last column change depending on the numbers in the first columns.

How do i do that?

[Katerina Kovriga _Stiltsoft_]

Hi @Team Awesome BVBA ,

The ability to perform calculations in Confluence tables directly is not possible at the moment, so you'll need some 3rd party add-ons to fulfil the task.

As my company develops the Table Filter and Charts for Confluence app, I can suggest trying its Table Transformer macro (if you prefer to work with native Confluence tables) or Table Spreadsheet macro (if you want to have a fully functional Excel sheet with cell formulas right in Confluence).

[Clara Vega _Simpleasyty_]

Hi @Team Awesome BVBA Yes, this is possible with Simple Table app.

If your table has columns like Defects total, Defects ok, and Defects nok, you can add a Calculated Column for the percentage, for example:

=("Defects ok" / "Defects total") * 100

This value is calculated dynamically for each row, so if the numbers in the other columns change, the percentage updates automatically as well. Simple Table supports calculated columns for row-based formulas and arithmetic expressions.

A simpler option, if you already have a native Confluence table on the page, is to keep that table and wrap it with the Simple Table bodied macro. That way, you can add the calculated column without rebuilding the table from scratch.

If you only need totals or summaries at the bottom, Footer Aggregation can also help with functions like Sum, Avg, Min, Max, and Count. But for a percentage based on other columns in the same row, Calculated Columns would be the right feature here.

Hope this helps!

[Shardul Juyal_Addteq_]

Hi @Team Awesome BVBA 

Calculations are not possible natively in Confluence. However, there are a lot of apps in the marketplace that will provide the same. 

With our app Excellentable spreadsheet for Confluence, you can use the same formulas as excel/google sheets and natively use spreadsheets in Excellentable.

Regards

Shardul Juyal