Question Re: Adding calculated rows in SAP Analytics Cloud table f... in Technology Q&A

Adding calculated rows in SAP Analytics Cloud table for lightweight calculations

paul_theconsultant — Fri, 03 Oct 2025 15:57:23 GMT

I am working on a P&L statement with several category trees. For example Expenses Category can include child-members such as: COGS, SG&A, and Depreciation & Amortization.

SAC has automatically summed up each category (tree) group.

In this case, I am trying to sum-up or subtract two (2) or more categories trees depending on the required calculation. My expectation is to display the calculated measure’s name e.g. Net Income and value below the used/existing measures. See example:

>Revenue	100
>Expenses	50
Net Income	50

Currently no values are been displayed only the formula cell references e.g. =A5-A6 or Sum (A5, A6). See attached the screenshots. Please note that (all) represents the totals of the entire column

The primary data is from an on-premise BW system and a flat file (blended data). SAP Analytics Cloud (SAC) tenant is not using a planning license.

Re: Adding calculated rows in SAP Analytics Cloud table f...

N1kh1l — Fri, 03 Oct 2025 16:20:56 GMT

@paul_theconsultant

Looking at your screenshot, should the formula not be SUM(B5,B6) as your values are in second column ? The other thing could be BW live connection might not be supporting cell level calculation in Tables.

Hope this helps !

Nikhil

Re: Adding calculated rows in SAP Analytics Cloud table f...

paul_theconsultant — Sat, 04 Oct 2025 07:22:08 GMT

Hi Nikhil,

Thank you for your response. I appreciate it. I have noticed that a formula text field appears on your end.

The connection of BW to SAC is through an import/acquired connection. I have added a new row and entered a hypothetical measure name: ‘NEW MEASURE NAME’ and tried the following formulas. See below the corresponding system messages and screenshot:

Formula	System message
=SUM(B5,B6) or =B5+B6	Formula entry on data cells is not allowed
SUM(B5,B6)	Value is not valid

Re: Adding calculated rows in SAP Analytics Cloud table f...

paul_theconsultant — Sat, 04 Oct 2025 11:47:44 GMT

Please ignore this response.

Re: Adding calculated rows in SAP Analytics Cloud table f...

paul_theconsultant — Tue, 07 Oct 2025 10:03:01 GMT

Hi everyone,

I discovered why the 'new row' only displayed the formula cell references e.g. =A5-A6 or Sum (A5, A6). I arrived at this when I right clicked the desired dimension row labels to add a calculation by selecting add a client calculation option from the context menu.

To resolve this, I navigated to the top right corner of your table: More Actions denoted by 3 dots in a circle. Then scrolled to Show/Hide option and deselected/unticked Formulas ie. More Actions > Show/Hide> Untick Formulas

After following the above step, the formula values displayed as desired and I proceeded to rename the new row (dimension row label) from the default numerical operation name e.g. Sum or Subtract.