Category:

Database related

Statistical (aggregate)

Standard

Returns the average value in a dataset field.

Syntax

dataset_avg(
  StepNo Integer,
  GroupLevel Integer,
  FieldName String
): Numeric

Parameters

StepNo specifies the export step, in which the function must be calculated. It is used in HTML export context only; in other cases this parameter is ignored.

GroupLevel is reserved for future use and currently must be 0.

FieldName is the name of the field to calculate.

Return value

Type: Numeric.

Examples of using

dataset_avg(1, 0, 'Salary')