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.

[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.