CelesteCS Math plugin lets one add live calculations to Confluence pages: enter a formula and it is evaluated on the server on every page view, so the shown result always reflects the current page data. It contains the following macros:
- Numerical Expression macro – the main macro; enter a formula in the macro body – a single expression, or several expressions embedded in text and enclosed in square or curly braces. Formula operands can be plain numbers, table cell values and ranges, the rendered output of other Confluence macros, and any of the built-in functions combined with the supported operations.
- Chart macro – New! Datacenter Only – renders a Bar, Line or Pie chart directly from a range of cells on the page, recalculated fresh on every page view.
The power of Numerical Expression is in the ability to use outside data as formula operands. Table cells are referenced in a simple Excel-like manner, for example 'ROUND(Table1.A2)'; cell ranges are also supported, for example 'SUM(Table1.A2:B10)'. The source table may be located on the current or another wiki page. A Confluence macro may also be specified as an operand – its rendered output is taken as plain text, so use the VALUE function to extract the first numeric value from it. If the formula text is formatted, the same formatting is applied to the output; to format the result explicitly (for example as a currency) use the FORMAT function.
Note for Cloud version: Math Cloud plug-in performs user-impersonated calls to Jira Cloud methods in JIRAISSUECOUNT, JIRAISSUEFIELDVALUES and JIRAISSUEFIELDVALUESBYFIELDID functions. This functionality is available when CelesteCS Math for Confluence Cloud - Jira Integration plug-in is installed on your primary Jira Cloud instance. Specifying non-primary Jira Cloud instances is not supported. So, if you need to use Jira-related functions on your Confluence Cloud, please, install the CelesteCS Math for Confluence Cloud - Jira Integration plug-in on your primary Jira Cloud instance.
Find out more here: