B.2 Cell on a Previous Row

You can reference the values of preceding rows by their relative offset from the current row. This feature is useful when creating differential formulas. The syntax is as follows:

field[relative position]['column name']

 

e.g.,

field[-1]['Total Sales']  // previous row, in 'Total Sales'

field[-3][3]              // three rows above, in column 3

To reference a cell by its absolute position, see Cell of Any Table.

<< B.1 Cell on the Current Row © 1996-2013 InetSoft Technology Corporation (v11.4) B.3 Column of Any Table >>