Category:

Database related

Statistical (aggregate)

Conditional

Returns the current dataset row count (accumulating) among records which satisfy a certain condition.

Syntax

dataset_row_count_ex(
  StepNo Integer,
  GroupLevel Integer,
  Condition String
): Integer

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.

Condition is a boolean expression. But it must be written as a String constant (i.e. enclosed in single quotes) or a string deterministic expression.

Return value

Type: Integer. Actually, inside the dataset rows loop, it returns the current row number (only within records which satisfy the Condition). In the end of the loop, it returns the number of all rows in the dataset (only within records which satisfy the Condition).

Examples of using

dataset_row_count_ex(
  1, 
  0, 
  'dataset_field_val(1, ''Age'') > 50'
)