Example (No data, unlocked cells)
When a value is top down spread in cells that contain no data, the new value is spread equally to the leaf members.
Quarter 3 2009 | July 2009 | August 2009 | September 2009 | |
---|---|---|---|---|
Los Angeles | 0 | 0 | 0 | 0 |
In this example, if 3,000 is specified for Quarter 3, then the 3,000 is spread equally to the three leaf members. Therefore, the amount spread to each of the three months is 1,000 (3000/3).
Quarter 3 2009 | July 2009 | August 2009 | September 2009 | |
---|---|---|---|---|
Los Angeles | 3,000 | 1,000 | 1,000 | 1,000 |