Aggregate Functions

Avg(Value) Evaluates the average of the values in the collection. [Products].Avg([UnitPrice])
Count() Returns the number of objects in a collection. [Products].Count()
Exists() Determines whether the object exists in the collection. [Categories][[CategoryID] == 7].Exists()
Max(Value) Returns the maximum expression value in a collection. [Products].Max([UnitPrice])
Min(Value) Returns the minimum expression value in a collection. [Products].Min([UnitPrice])
Single() Returns a single object from the collection. [Accounts].Single() is not null
Sum(Value) Returns the sum of all the expression values in the collection. [Products].Sum([UnitsInStock])
Thursday, 27 December 2018 Posted in Expressions Constants, Operators, and Functions