Performing What If Analysis

Before you commit data by saving it, you can perform "what if" calculations and review the changes.

By experimenting with data, you can see the impact of various scenarios before saving the data, which is useful for manipulating values to produce the results you want.

You can manipulate data values by:

• Entering values (see Entering Data Quickly Using Commands).

• Locking a value during spreading (see Locking Cells).

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

• Using ad hoc functionality in Planning and Oracle Smart View for Office (see Using Ad Hoc for Data Entry and Analysis).

• Experiment with various outcomes in "sandboxes" (see Keeping Your Work Private with Sandboxes).

To perform quick calculations on a value:

1. Select the cell to perform a calculation on.
2. Enter an operator (+, +–, *, /, or %), and then enter a value.
3. Move the cursor from the cell.

   A color change indicates a modified cell.