AggregateFunction Enumeration

Visual Basic (Declaration)
Public Enum AggregateFunction Inherits System.Enum

C#
public enum AggregateFunction : System.Enum

Member	Description
AggregateIf	Returns an aggregate of values where inclusion in the aggregation is determined by a specified expression. Syntax: AggregateIf( ConditionalExpression, AggregateFunction , AggregateFunctionArguments ) Parameters: ConditionalExpression: An expression that evaluates to a boolean that is used to determine if the current data row is to be included in the aggregation. AggregateFunction: The type of aggregation to use. Valid values are Sum, Avg, StDev, StDevP, Var, VarP, Median, Mode, Min, Max, Count, CountDistinct and DistinctSum. AggregateFunctionArguments: The arguments needed for the aggregation defined by the AggregateFunction parameter. Examples: 'To return the Count of grade fields where the field Grade is greater than 90: =AggregateIf(Fields!Grade.Value > 90, Count, Fields!Grade.Value)
Avg	Returns the average of all non-null values of the expression.
Calculated	The value must be calculated over other aggregate values.
Count	Returns the count of all non-null values of the expression.
CountDistinct	Returns the count of all distinct non-null values of the expression.
CountRows	Returns the count of all rows.
Default	The default aggregate function inferring from a result type of an expression.
DistinctSum	Returns the sum of the values returned by the specified expression using only the rows when the value of another expression is not repeated. Syntax: DistinctSum( Distinct_Value, Data_Value ) Parameters: Distinct_Value: An expression that evaluates to a value that if unique the data row will be included in the sum. Data_Value: An expression that evaluates to a numerical value to be summed. Examples: =DistinctSum(Fields!OrderID.Value, Fields!OrderFreight.Value)
Max	Returns the maximum of all non-null values of the expression.
Median	Determines the median value for a list of facts.
Min	Returns the minimum of all non-null values of the expression.
Mode	Determines the mode value for a list of facts.
StDev	Returns the standard deviation of all non-null values of the expression.
StDevP	Returns the population standard deviation of all nonnull values of the expression.
Sum	Returns the sum of all values of the expression.
Var	Returns the variance of all non-null values of the expression.
VarP	Returns the population variance of all non-null values of the expression.

System.Object
   System.ValueType
      System.Enum
         GrapeCity.ActiveAnalysis.Schema.AggregateFunction

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

GrapeCity.ActiveAnalysis.Schema Namespace

Syntax

Members

Inheritance Hierarchy

Requirements

See Also

Reference