Performing “What If” Analysis

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

You can manipulate data values by:

Typing 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 Hyperion Smart View for Office, Fusion Edition (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 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.

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