Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
List.MaxN(list as list, countOrCondition as any, optional comparisonCriteria as any, optional includeNulls as nullable logical) as list
About
Returns the maximum value(s) in the list, list. After the rows are sorted, optional parameters may be specified to further filter the result. The optional parameter countOrCondition specifies the number of values to return or a filtering condition. The optional parameter comparisonCriteria specifies how to compare values in the list.
list: The list of values.countOrCondition: If a number is specified, a list of up tocountOrConditionitems in ascending order is returned. If a condition is specified, a list of items that initially meet the condition is returned. Once an item fails the condition, no further items are considered.comparisonCriteria: [Optional] An optionalcomparisonCriteriavalue can be specified to determine how to compare the items in the list. If this parameter is null, the default comparer is used.