GroupByLE Function

Description:

Returns the second part of a list of pairs where the first part is less than or equal to the compared value.

Returns:

Any*

Parameters:

Parameter	Data Type	Description
1	Any**	The list of pairs
2	Any	The compare value.

Examples:

When using functions inside a field, remember the field brackets:

{GroupByLE(InterestRatesCompaniesList, BaseRate)}

Expression	Result
GroupByLE( List(List("a","z"),List("b","y"),List("a","x"),List("c","w")), "a" )	List("z", "x")
GroupByLE( List(List("a","z"),List("b","y"),List("a","x"),List("c","w")), "c" )	List("z", "y", "x", "w")
GroupByLE( List(List("a","z"),List("b","y"),List("a","x"),List("c","w")), "d" )	List("z", "y", "x", "w")

This article applies to: