Inter-record functions

Inter-record functions are used:

  • In the load script, when a value from previously loaded records of data is needed for the evaluation of the current record.
  • In a chart expression, when another value from the data set of a chart is needed.
Note: Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when chart inter-record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.
Note: Self-referencing expression definitions can only reliably be made in tables with fewer than 100 rows, but this may vary depending on the hardware that the engine is running on.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Row functions

These functions can only be used in chart expressions.

Column functions

These functions can only be used in chart expressions.

Field functions

Pivot table functions

These functions can only be used in chart expressions.

Inter-record functions in the load script

See also: