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?
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).
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
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!
Hi, I'm with CelesteCS (Math for Confluence Cloud) - this is a straightforward case for our Numerical Expression Cloud macro. For a per-row percentage like yours: ROUND(Table1.C2/Table1.B2*100;1)
It's a live formula, so it recalculates automatically whenever the table values change. If you want the same ratio as a running SUM across the whole table instead of per row, that's
SUM(Table1.C2:C20)/SUM(Table1.B2:B20)*100
A worked example of per-row formulas like this: https://celestecs.com/blog/calculating-one-column-from-another-per-row-formulas
It looks like you're new here. Sign in or register to get started.
