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: Select the cell on which to perform a calculation. 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 Move the cursor from the cell. A change in color indicates the modified cell.
Scripting on this page enhances content navigation, but does not change the content in any way.