How to do calculation on the issue form in JIRA (without using JIRA Misc Custom Fields) the or calculation on the page in Confluence?

[Karmen Cheung]

How to do calculations on the issue form in JIRA (without using JIRA Misc Custom Fields since I use the cloud service only and it only supports server platform) or do the calculations on the page in Confluence?

[CelesteCS]

Hello, Karmen!

For any calculations in Confluence, including any manipulations with table data and output of third-party macros, like JIRA Issues macro, you may use CelesteCS Math for Confluence.

Assume you have a table with three columns and three rows on your page – from A1 till C3, where row 1 is the header row. The sum calculation formula for rows 2 and 3 will be simple:

SUM(Table1.A2:C3)

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

Thanks!

[Nic Brough -Adaptavist-]

You'll need to find or write a "connect" add-on to provide that - I'm not aware of any that do it at the moment, but have a look at the marketplace.