Using an Excel Formula to Recalculate or Display Measure Value Changes

You can use an Excel formula to recalculate or display measure value changes. In addition to the cell value, the Excel formula shows the measure dependency so that you can see how the measure is calculated.

For example, assume you have the following formula:

Ending Inventory = Beginning Inventory + Plan Build

When Show Excel Formula is turned on, for the Ending Inventory measure, in addition to the value, you can see how the measure is calculated. For example: 

E5=E4+E3

where E4 is the cell location for the Beginning Inventory and E3 is the cell location for the Build Plan.

If any dependent measures are not in the display, the cell location is replaced by a value. In the previous example, if Beginning Inventory is not in the display (hence the cell address is not available) the formula for Ending Inventory would be:

E5 = 120 + E3

Tip:

Click Calculate button to permanently save the changes to the dependency measure.

  To show Excel formulas:

  1. In an Excel planning worksheet, click View Display Options button, or select Oracle, and then View Display Options.

  2. Select Show Excel Formulas.

  3. Click OK.