Show TOC

Report Writer: Calculating Cells for More Than One Block

Description

When calculating cells in previous releases, you could only refer to a report cell with one row and column block. You can now use cells in more than one block.

When defining a cell, you can decide if a cell is to be used as it was previously (local cell) or if it should be used for more than one block (global cell). In order to use a cell for more than one block, you must set the indicator 'Global' in the list of the cells to be defined. You must specify the number of the row block and the column block for a global cell as well as a coordinate for each row and column characteristic. You define the global cell in the same way as you define a cell in a key figure block.

Further notes

You can for example, define the following report using global cells:

The first row block displays costs and the second row block displays the number of employees. You can now define a column for the first row block which displays the costs per employee. To do so, you must define a cell for the number of employees.