Aggregate Functions

Operate across collection items to return aggregate values.

All Function	Description
Average	Returns the average of a specified field or expression across a collection.
Avg	Returns the average of a specified field or expression across a collection.
CollectionLookup	The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression.
Count	The Count function returns the number of members in a collection.
GetFirst	The GetFirst function returns the first collection member that satisfies a given filter expression.
GetFirstValue	Returns the specified field value of first member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified.
GetLast	The GetLast function returns the last collection member that satisfies a given filter expression.
GetLastValue	Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified.
GetMember	Returns the first member that matches the filter criteria.
GetMemberByIndex	Returns the member at an index in a collection which can be ordered and filtered using filter expression.
GetMemberValue	The GetMemberValue function returns the specified field value of the first collection member that satisfies a given filter criteria.
GetMemberValueByIndex	Returns the specified field value of member at an index in collection which can be ordered and filtered using filter expression.
Max	Returns largest value of a member field or expression across a collection.
Min	Returns smallest value of a member field or expression across a collection.
Sum	Returns the sum of a specified member or expression across a collection.
ToList	Returns a list object from a collection.