Is there a way to create calculated fields in Confluence Databases and use them in grouped views?

[Mark Pliacnik]

I’m trying to use Confluence Databases for reporting, but I’m not sure if it supports calculated fields in the way I need.

I’d like to work with data in the same view, create values based on other columns, and use that together with grouped results or summaries.

I can see some reporting features in Databases, but I’m not sure whether this level of calculation is supported natively. Has anyone handled this kind of setup in Confluence?

[Clara Vega _Simpleasyty_ · Accepted solution]

Hi @Mark Pliacnik 

You’re right to question the native behavior here. At the moment, Confluence Databases can do simple calculations at the bottom of a field and save them as part of a view, but they still don’t offer a true formula/calculated field that evaluates per row. Atlassian also has an open suggestion for that in CONFCLOUD-78459.

Also, the documented database layouts today are Table, Card, and Board. The Board layout can group entries by a tag field, but that is different from having a reusable calculated field for grouped reporting.

If you need that behavior now, Simple Table app is a good fit here. It supports calculated columns with formulas such as =price * quantity, evaluates them per row, and lets you group by one or more columns with aggregations like Sum, Average, Min, Max, Count, and Count distinct shown in the group rows.

So in practice, this is not available natively in Confluence Databases in the way you describe, but yes, you can do it with Simple Table for Confluence. It also supports footer aggregations if you want an overall total at the bottom of the table as well.

Hope this helps!

[Tomislav Tobijas]

Hey @Mark Pliacnik ,

Yeah... Databases only support simple calculations as described here. We're mainly talking about sum, average, median, etc. 🔣

Potentially, you could replicate behavior in Jira. Team-managed spaces do support formatted fields, or you could also try JPD, which also has fields that support formulas.
Although all of that does mean you'd have to switch to Jira.

There are a couple of feature suggestions for what you're looking for:

• CONFCLOUD-78459: Add support for math expressions and formulas in Confluence Databases 
• CONFCLOUD-78078: New field type: "Formula" for Confluence Databases 

Cheers,
Tobi

[Arkadiusz Wroblewski]

Hello @Mark Pliacnik 

not at the moment, at least not as a real calculated field.

Confluence Databases can do simple column totals at the bottom, but that is not the same as a formula field that calculates a value per row and can then be used for filtering or grouping.

So for something like Amount × Rate, you currently need a workaround: either calculate it outside Confluence and write the result back into a normal field, or use an app if you need real formula behavior.