Example 1

Before locking and spreading, Account A has the values described in the following table:

You then lock the Feb and Mar values at 100 and change Q1 from 300 to 600. Because Jan, Feb, and Mar must now total 600, and Feb and Mar are locked at 100 each, Oracle Hyperion Planning calculates Jan to be 400 and fills in that value.

After locking and spreading, the data displays as shown in the following table:

Example 2

Before locking and spreading, Account B has the values described in the following table:

You then lock Q1 and Q2 values at 100 each and change Year Total from 400 to 800. Because the yearly total must equal 800, and Q1 and Q2 are locked at 100 each, Planning calculates Q3 and Q4 to be 300 each and fills in those values.

After locking and spreading, the data is displayed as shown in the following table: