Row, Column, or Cell Reference Arguments

The syntax for a row, column, or cell argument is:

Note:

A validation error occurs if the user does the following: A column-level formula contains a row reference or a row-level formula contains a column reference.

FunctionName(GridName.GridElement[segment(range)])

Table 10-1 Argument Components

Argument	Description
`GridName`	(Optional) Name of a grid. For example, `Difference (grid1.row[5], grid2.row[5])` returns the difference of two rows on grid1 and grid2. If `GridName` is not specified, the default is the current grid where the formula is entered. If a `GridName` has a space in it (for example,. Income Statement), when using it in a formula, it needs to be surrounded by quotes (for example, "Income Statement"). You can reference another grid row or column within the same report by prefixing the row or column reference with the grid name. For example, in Grid 1, in a formula row, you can refer to row 1 in Grid 2 with the following: "Grid 2".[1]
`GridElement`	(Optional) One of the following keywords: `row`, `col`, `column`, or `cell`. For example, `Max(row[1], row[2], row[3])` returns the maximum value of three rows. (The keyword `row` and `column` or `col` is optional.) You must specify row and column segment IDs. For example, `cell[2, A]` refers to the cell that is the intersection between row 2 and column A. The keyword `cell` is optional. For example, `[5,B]` refers to the cell that is the intersection between row 5 and column B. Cell references can use `[row, col]` syntax or `[col, row]` syntax. Note: The keyword cell is optional. For example, [5,B] refers to the cell that is the intersection between row 5 and column B. Cell references can use [row, col] syntax or [col, row] syntax. The keywords row and column are also optional. For example, [5] refers to row 5 and [C] refers to columns C If `GridElement` is specified, letters represent columns and numbers represent rows; for example, `Max ([1,A], [2,A], [3,A])`
`segment`	(Required) Row, column, or cell reference number of a grid. For example, `[2]` addresses row segment 2. Segments are enclosed in square brackets [ ].
`range`	(Optional) Rows, columns, or cells that are expanded from the specified segment. If `range` is specified, the formula is calculated using only the specified range. For example, `row[2(3:5)]` uses only the 3rd through 5th rows of expanded segment 2. When `range` is not provided, all expanded cells are used. Note: If a segment expands to only one row or column, do not use the `range` argument.