Adding calculated rows in SAP Analytics Cloud table for lightweight calculations

[#1]

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.

[paul_theconsultant]

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.

[N1kh1l]

@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

[paul_theconsultant]

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

[paul_theconsultant]

Please ignore this response.