You can lock the values of data cells and total cells. By locking values, you can prevent them being changed by a new totals or new summands.

The function Lock Cells On / Off can be used in planning layouts with simple key columns. It can also be used on the period screen. In layouts with a complex key column, this function is not available in the overview screen.

Place your cursor on a total or subtotal on the overview screen or period screen of a layout with one or several simple key columns.

You can lock or unlock the values of total cells and data cells by choosing Edit® Lock Cells On / Off or with the relevant push button.

Locked data cells are set to not ready for input. This is also the case for total cells if they were previously ready for input.

To do this define a new column in the layout definition in the Report Painter by double-clicking next to the heading of the respective key figure column. In the first dialog box, choose the element type "attribute" and in the second the attribute "Locked cell". In the element definition, define the same characteristics combination as for the corresponding key figure column. If necessary, define a suitable heading.

When entering data in a total cell, all locked cells are disregarded when the data is distributed. If a subtotal is locked, its summands count as locked for a superordinate total.

When entering data in a summand with a locked total, all other unlocked summands are changed proportionately so that the total remains constant.

You have the following options for navigating within manual planning:

• Navigate back to the characteristics screen or restart manual planning:

• Choose new characteristics combinations

• Navigation from the overview screen to the period screen

• Navigation from the period screen to the overview screen

You now enter values in the totals:

When you confirm your entries you obtain the following result:

The calculation is made as follows:

New total / old total = 180,000 / 90,000 = 2

Therefore the values of all cells that are not locked are multiplied by 2

Note that the locked cell was not taken into consideration in the calculation of the new and old totals.

You now enter a value in row 3.

You confirm your entries and obtain the following result:

The calculation is made as follows:

( new total – new value cell 3 ) / ( old total – old value cell 3 ) = 150,000 / 120,000 = 1.25

So, the values of all unlocked cells without data entry are multiplied by 1.25.

Note that the locked cell was not taken into consideration in the calculation of the new and old totals.

You now enter the subtotal:

You confirm your entries and obtain the following result:

The entry in the subtotal is distributed amongst the summands that are not locked.

You now enter the final total:

You confirm your entries and obtain the following result:

If the subtotal is locked, all the summands belonging to it are also counted as locked and therefore remain unchanged if data is entered in a superordinate total.