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).

[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