Performing “What If” Analysis

Before you commit data by saving it, you can perform “what if” calculations and visually review the changes. By experimenting with data, you can see the impact of various scenarios before saving the data—useful for manipulating values to produce desired results.

You can manipulate data values by:

  • Entering values (see Entering Data)

  • Locking a value during spreading (see Locking Cells)

  • Changing values by typing an operator, followed by a number, described here

  • Using the ad hoc functionality in Planning and Oracle Smart View for Office (see Working with Ad Hoc Grids)

  To perform ad hoc calculations on a value:

  1. Select the cell on which to perform a calculation.

  2. Enter an operator ( +, +–, *, /, or %), and then enter a value.

    The following table provides examples of using operators and values to produce results:

    Operation

    Initial Value

    Input Text

    Result

    Add +

    100

    +50

    150

    Subtract + -

    100

    +-50

    50

    Multiply *

    100

    *5

    500

    Divide /

    100

    /5

    20

    Percentage %

    100

    %25

    25

  3. Move the cursor from the cell.

    A change in color indicates the modified cell.