SAP Note 21760 - Cell calculation: not all levels have values

Symptom:

A report has a column formula referring to a cell. The column formula is not evaluated for all rows.
Key words: Report Writer, cells

Cause and prerequisites

The cause is a different treatment of the symbolic names in the Report Writer. There are two cases to be considered for the cell assignment:

1. If the symbolic name is specified in the set row, the row coordinate thus defined is valid for the entire hierarchy of the row set and addresses the report row assigned to the set or value entered in the set row.

2. If the symbolic name is specified in the header of the set, it only applies to the subhierarchy represented by this set. The rows in the report, that belong to the superior set node, do not belong to the validity range of the row coordinate.
In this case, you can additionally enter a level for the row coordinate when defining the cells. This level specifies to which summation level of the subhierarchie the cell is to refer. It is thus possible, for example, to print percentages with reference to the current subtotal.

In formula columns with cells, values are only calculated in the rows that belong to the validity range of the row coordinate. The report cells outside the validity range contain the value 0.
Example:

| (1) | (2) | (3) | (4) |
| Year | Formula | Formula | Formula |
-------------------|---------|---------|---------|---------|
ACCOUNT-01 | 100,00 | 20,00 | 20,00 | 20,00 |
ACCOUNT-02 | 400,00 | 80,00 | 80,00 | 80,00 |
* Account group 1| 500,00 | 100,00 | 100,00 | 100,00 |
ACCOUNT-03 | 600,00 | 120,00 | | 40,00 |
ACCOUNT-04 | 900,00 | 180,00 | | 60,00 |
* Account group 2| 1500,00 | 300,00 | | 100,00 |
** all accounts | 2000,00 | 400,00 | | |

Column (2): Column (1) in percent of account group 1 (500,00)
Column (3): Column (1) in percent of account group 1 (500,00)
but only for the accounts of account group 1.
Column (4): Column (1) in percent of the respective account group
(500,00 or 1500,00).


Row set:

Set name symb.
RNo Set/Value Name
-----------------------------------------------
Header: RACCT-ALL ALL
Rows: 010 RACTT-GR1 GR1Z
020 RACTT-GR2 GR2Z

Header: RACCT-GR1 GR1K
Rows: 010 KONTO-01
020 KONTO-02

Header: RACCT-GR2 GR2K
Rows: 010 KONTO-03
020 KONTO-04
-----------------------------------------------


Column set:

Set name symb.
ZNr Value/Formula Name
-----------------------------------------------
Header: RPMAX-JAN
Rows: 010 1..12 YEAR
020 = / *100
030 = / *100
040 = /*100
-----------------------------------------------


Cell assignment:

CELL1 CELL2 CELL3
-----------------------------------------------------------
Column coordinate YEAR YEAR YEAR
Row coordinate GR1Z GR1K ALL
Level 2 *)
addressed value(s) 500,00 500,00 500,00
1500,00
-----------------------------------------------------------
*) Level 2 has the effect that the symbolic name ALL no longer
addresses the top node in the set RACCT-ALL but the
subordinate nodes RACCT-GR1 and RACCT-GR2.

Solution
Place the symbolic name in the row set possibly into the set row of the superordinate set.


Additional key words

----- SUPPORTGUIDE 20010411140028 -----
REPORTWRITER, SGRW_FORMULA, SGRW_AMOUNT, SGRW_RC_STRUCTURE, SGRW_DATA, SGRW_DOCU_CONS_NOTE
SGRW_OM SGRW_PS SGRW_PC SGRW_SL SGRW_PCA SGRW_EC SGRW_LIS