RR Function
The RR function returns the value of a cell in a table relative by row to the current cell. This function is useful for referencing cells in a table where the total number of rows may change. If a row is inserted, the RR function will adjust accordingly to preserve the linkage.
Syntax
RR(integer)
Positive integers tell CaseView to look in rows below the current point.
It follows that negative integers tell CaseView to look in rows above the current point.
Example
RR(2)
Entering RR(2) in table cell A.A1 returns the value in table cell A.A3, the cell two rows below.
Note: This function can also be used in Skip and Hide conditions for paragraphs within a table as shown in Example 2.
Example 2
A paragraph in table cell B3 has a skip condition containing the function RR(-1). CaseView will look at cell B2, to get the value for the skip condition and skip the paragraph accordingly.
Example 3
The function also accepts an additional parameter that allows it to re-reference automatically.
RR(2#)
Entering RR(2#) in table cell A.A1 returns the value in table cell A.A3, the cell two rows below. If any rows are inserted or deleted between the cell containing the formula and the source cell, or if either cell is renumbered, the formula automatically renumbers to reference the original cell. For example, if a row were inserted between row 1 and row 3, the formula would update to read RR(3#).
