How to perform summation (row wise and column wise) ad subtraction (row wise and column wise)

[Jitendra Shembekar]

Hi

Want to perform simple summation and subtraction in confluence using table transformer or some other way.

Below are the four conditions. 

Thanks in advance for your help.

[Ditte Simard]

Unfortunately there is no way to do this out of the box with Confluence.  I would recommend that you check out Stiltsoft's "Table Filter and Charts for Confluence" application:  https://docs.stiltsoft.com/tfac/cloud/welcome-to-table-filter-and-charts-for-confluence-42239760.html

You can do all sorts of table calculations using the Table Transformer macro that is included in the app.

[Stiltsoft support]

Hi @Jitendra Shembekar ,

As you've mentioned the Table Transformer macro, it looks like you do have our Table Filter and Charts for Confluence app installed.

So, as @Ditte Simard has kindly mentioned, this macro really allows you to perform such calculations.

And to calculate the row and column sums automatically, you may use our Table Filter macro (go to the Calculations tab and check the "Operation type for Total column" and "Count totals for columns" options).

And if you want to work with Excel-like functions, you may choose the Table Spreadsheet macro with cell formulas.

[Jitendra Shembekar]

Hi @Stiltsoft support - No I dont have the said app installed. So I won't see 'Calculations' tab.

Is there a sql qury that you may help with for the above cases.

Thanks!

[Stiltsoft support]

Hi @Jitendra Shembekar ,

Sorry then, I was confused by you mentioning the Table Transformer macro: Table Transformer, Table Filter, Table Spreadsheet, Pivot Table, Chart from Table and other macros with the "Table" prefix are the part of the Table Filter and Charts for Confluence app.

If you don't have the app installed, then, of course, you don't see these macros.

So, please define what app is installed for your instance - as you want to use SQL query and it is not possible natively, I assume you have some additional apps.