Specifying default rows in time grid attributes

Managing products and portfolios : Financial planning using time grid attribute : Working with the time grid editor : Specifying default rows in time grid attributes

You can set default values for the rows in a time grid attribute. The default value is applied to all cells in the row, except for cells that contain manually entered information. You can edit one row to update all sheets simultaneously. The time between the start and end date must be the same for all sheets.

Before you begin

You must be an administrator to configure attributes. Default values are numeric, and can be entered as expressions that are composed of numbers or references to other cells, rows or attributes, combined with the operators that are allowed in time grid attributes.

Procedure

1 Select a time grid attribute or click Add attribute and select Time Grid.

2 In Default Row Value, type a default value for the row.

3 Click OK.

Results

The new default value is applied to all cells in the rows that are empty, or that have a previous default value.

Example

Default values are composed as expressions. The following types of default row expressions are valid:

Expression	Example
Numbers	100 or 3,14 (depends on the locale)
A reference to another cell within the sheet	='A2'
A reference to a corresponding cell in another row	='A row name'
A reference to a float or integer attribute	='An attribute name'
Any operator that is valid for the time grid attribute	+ - / * ^
A combination of numbers, references, and operators	=('A2'+'row name')*100