Goal Seek Function (SAP Library - Special Purpose Ledger)

Goal Seek Function

Use

The goal seek function is used in manual planning to find the content of a cell automatically by referencing another cell that shares the first cell's function. The cell whose content is to be sought is referred to as the source cell. The target cell must be linked to the source cell by a formula and must represent the result of this formula.

You can enter a value - the target value - for the target cell in the goal seek function. After the function has been carried out, the value necessary for reaching the target value is written to the source cell. In this way, the system simulates manual entry.

Your planning layout contains, among others, the following columns: planned revenue, planned quantity and planned price. The planned revenue is the product of planned quantity and planned price.

When entering planning figures, you can use the goal seek function to produce in the planned price cell the value required in order to attain a certain target revenue, such as 120,000 USD. Select the planned price as the source cell and the revenue as the target cell. Ensure that there is a value in the planned quantity cell.

Since the source cell must always be the cell unlocked for manual entry, the system automatically designates as source cell that cell of the selected pair that is unlocked. If both of the selected cells are unlocked for entry, you can switch the cells round after having selected the goal seek function and then specify the source cell.

Prerequisites

Your current planning layout should always contain formulas or ratios.

You need to select two cells and ensure that at least one of those selected - the source cell - is unlocked for manual entry.

All cells used to calculate between the source and target cells must have entries.

Neither of the selected cells should be the totals row.

Activities

Select just two cells.

Choose Edit ®Goal seek.

If necessary, change around the source and target cells.

Enter a target value.

If you want to cancel the result produced by the goal seek function, choose Edit ® Undo ® Undo entry.