Adding calculated rows in SAP Analytics Cloud table for lightweight calculations

[paul_theconsultant]

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.