Roll Forward Tab - Edit Cell Dialog

Use this command to modify the value of a cell during a year-end close.

Pull Value By

You can replace the current value of the cell with that of another cell in the document or a different calculation. To modify the value of the cell during a roll forward, select the option you want in the Pull Value By drop-down and then type or select the replacement value in the box provided.

Select
None	Retains the current calculation during a year-end close.
Direct Reference	Direct Referencing returns the value of another cell number to the current cell.
Relative Reference	Returns the value of an expression as the equivalent cell number in the new year's file. Relative referencing is useful if you have a prior year column with cell numbers in the 100 range and a current year column in the 1000 range. A relative reference 1000 adds 1000 to the current cell number and then finds the cell with that number and returns the value. This would be useful if numbers were manually plugged and it is now necessary to transfer current year balances to the prior year cells during a roll forward.
Relative Column Reference	Replaces the value of the current cell with the value of the equivalent cell number in the new year's file specified relative table. Allows the user to roll forward a table cell from using a relative column RC() function.
Equation	Replaces the value of the current cell with a new value or expression you create.

Direct Reference

Direct Referencing returns the value of another cell number to the current cell.

Pull Value from Cell

Select the cell whose value you want to appear in the current cell following a year end close.

Click the Pick Cell button to launch the Cell Picker dialog.

Note: If the current cell is within a table and the reference points to cell outside the table, ensure the cell number is preceded by double-colons (::). This switch tells CaseView to look outside the table for the cell number.

Relative Reference

Returns the value of an expression as the equivalent cell number in the new year's file. Relative referencing is useful if you have a prior year column with cell numbers in the 100 range and a current year column in the 1000 range. A relative reference 1000 adds 1000 to the current cell number and then finds the cell with that number and returns the value. This would be useful if numbers were manually plugged and it is now necessary to transfer current year balances to the prior year cells during a roll forward.

Offset Current Cell # by

For example, R(-2) returns the value of the cell whose number is two less the current cell number. If the current cell has a cell number of c50, the value of cell number c48 will appear in the current cell after a roll forward.

Relative Column Reference

Replaces the value of the current cell with the value of the equivalent cell number in the new year's file specified relative table. Allows the user to roll forward a table cell from using a relative column RC() function.

Offset Current Cell # by

For example, RC(-2) returns the value of the cell whose column location is two less the current cell number. If the current table cell has a cell number of ABC.C50, the value of cell number ABC.A50 will appear in the current cell after a roll forward.

Roll Forward Expression

If the Equation option was selected from the drop-down list, enter the roll forward calculation.

(R(#) substitutes current cell number offset by #.)

Enter the expression you want to control the value of the cell during a roll forward.

Options

Select the actions for CaseView to take on input cells and override flags during a roll forward.

Clear Input Cells

To clear input entered in the Form Mode for the current cell only, select the Clear Input Cells check box.

Clear Overridden Flag

To return the calculated value to the cell, click Clear Overridden Flag.

Only pull Overridden

To transfer the values of only those cells that are overridden to the current cell, select Only pull Overridden. With this set, and using the direct and relative reference Pull Data from options, only cells that are overridden will have their values transferred to the current cell.

Notes

• The roll forward value is not a complete interpreter expression, it does not allow for values to be pulled from XWKS() calculations.
• Roll forwards to cells outside of the table may not update properly. If linking to a cell outside a table make sure the "::" operator is used.
• Roll forward equations can now use the value of the current cell as part of the expression, either through a direct entry of the cell number or using the expression R(0).
• When performing a year-end close, the option to "Update CaseView Roll Forward Cells" must be selected. This will cause CaseView to launch briefly during the year-end close process to search for and update any cells set to roll forward.

Related Topics

• Edit Cell