Developer Transformation Guide

10.4.0
- 10.5.2
- 10.5
- 10.4.1

Back Next

CONSOL_MIN

Analyzes a port in the record group and returns the lowest value.

Syntax

CONSOL_MIN(string, group by)

The following table describes the arguments for this command:

Argument	Required/Optional	Description
string	Required	Input port name.
group by	Required	Name of the input port that contains the group identifier.

Return Value

The lowest port value.

For the String datatype, the function returns the shortest string. For the Date/time datatype, the function returns the earliest date.

Example

The following expression uses the

CONSOL_MIN

function to analyze the SalesTotal input port and find the lowest value:

SalesTotal1:= CONSOL_MIN(SalesTotal, GroupKey)

In this expression, the

CONSOL_MIN

function uses the GroupKey port to identify a record group. Within that record group, the function analyzes the SalesTotal port and returns the lowest value. The expression writes this value to the SalesTotal1 output port.

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

CONSOL_MIN

CONSOL_MIN

Syntax

Return Value

Example