Map and Table Calculation

Predefined variable %R

Variable to calculate with record numbers in a table.

Syntax

Notes:

R stands for Record number.
When a table uses system domain None, the record numbers are listed along the left of the table.
When a table uses another domain, the order of the domain items in the domain of the table are used.

Normally, column calculations are performed on the values of all records of specified columns. However, if you wish to perform an operation on specific records, you can indicate so by using [%R] as an index behind a column name in an expression.

Column[expr]	to use values of a column indexed by record values, class names or IDs
Table.Column[expr]	to use values of a column in another table, indexed by record values, class names or IDs
Table.Ext.Column[expr]	to use values of a column in a table with another extension than .tbt (e.g. .his), indexed by record values, class names or IDs.

In between the square brackets, you can write an expression expr containing %R.

Tip:

When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.

Usable in

TabCalc

Examples

TabCalc example:

OutCol1 = %R

OutCol2 = OutCol1[%R+1] - OutCol1[%R]

OutCol3 = (OutCol1[%R-1] + OutCol1 + OutCol1[%R+1]) / 3

Domain	MyValue	OutCol1	OutCol2	OutCol3
Glacial deposits	10	1	10	?
Lake deposits	20	2	10	20
Old alluvial deposits	30	3	40	40
Quartzites	70	4	10	60
Recent alluvial deposits	80	5	40	80
Shales	90	6	10	100
Siltstones	130	7	10	120
Slope deposits	140	8	?	?

Column OutCol1 contains the record numbers of the items in domain Geology; this domain is used by the table.
Column OutCol2 contains the difference of each record in column MyValue and its successive record, e.g. for the first record: 20-10 = 10.
Column OutCol3 contains the average value of each three successive records in column MyValue, e.g. for the second record: (10+20+30) / 3 = 20.00