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.

Suppression of zero values is automatically disabled when these functions are used.

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:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?