GroupByGT Function

Description:
Returns the second part of a list of pairs where the first part is greater than 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:
{GroupByGT(InterestRatesCompaniesList, BaseRate)}
Expression
Result
GroupByGT( List(List("a","z"),List("b","y"),List("a","x"),List("c","w")), "a" )
List("y", "x", "w")
GroupByGT( List(List("a","z"),List("b","y"),List("a","x"),List("c","w")), "c" )
List()
GroupByGT( List(List("a","z"),List("b","y"),List("a","x"),List("c","w")), "d" )
List()

Related content