Adding calculations to your page is easy. Here is how to do it:
- While editing your page, choose Insert -> Other macros -> CelesteCS Numerical Expression to add the macro to your page.
- Specify macro parameters. There you may choose whether to take table values from the macro body only or from the whole page, plus, select how the formula is specified – in curly or square braces within the text or whole macro body is the formula.
- In the macro body specify the formulayou would like to calculate, for example “(Table1.A2 + 20) / 7”. You may insert table cell values and other macros right into the formula.
- Save the page and enjoy the result.
Example: a Numerical Expression in each row calculates the total including tax from the cells of the same row.
Works well with
CelesteCS Math shares its formula engine with two other CelesteCS apps, so the functions and operations you already use in Math work there too:
- CelesteCS Conditions – conditional formatting for Confluence tables: highlight cells and rows by rules or formulas, add color scales, data bars and icon sets. View on Atlassian Marketplace
- CelesteCS Reporting – build tables and lists from Confluence pages, Page Properties and Jira issues, with calculated columns, totals, filtering and sorting. View on Atlassian Marketplace
Math saves you time? A review on the Marketplace helps other teams find it.