AggregateOperand.Sum(CriteriaOperator) Method

Creates a new AggregateOperand which returns the sum of values calculated by the given aggregate expression. This expression is evaluated against elements of the AggregateOperand.CollectionProperty that match the specified AggregateOperand.Condition.

Namespace: DevExpress.Data.Filtering

Assembly: DevExpress.Data.v23.2.dll

NuGet Package: DevExpress.Data

Declaration

C#

public AggregateOperand Sum(
    CriteriaOperator aggregatedExpression
)

VB.NET

Public Function Sum(
    aggregatedExpression As CriteriaOperator
) As AggregateOperand

Parameters

Name	Type	Description
aggregatedExpression	CriteriaOperator	A CriteriaOperator object which specifies the aggregate expression.

Returns

Type	Description
AggregateOperand	An AggregateOperand object which calculates an aggregate expression.

Example

Example 1

Get the sum of values from a whole collection

Expression:

LINQ

CriteriaOperator.FromLambda<Order, int>(o => o.OrderItems.Sum(oi => oi.ItemPrice));

Typed

new AggregateOperand(new OperandProperty(nameof(Order.OrderItems)), new OperandProperty(nameof(OrderItem.ItemPrice)), Aggregate.Sum, null);

String

CriteriaOperator.Parse("OrderItems.Sum(ItemPrice)");

Test

Input:

Order	OrderItemName	ItemPrice
Order0
	OrderItem1	10
	OrderItem2	20

The result: 30

Example 2

Get the sum of values from a filtered collection.

Expression:

LINQ

CriteriaOperator.FromLambda<Order, int>(o => o.OrderItems.Where(oi => oi.IsAvailable == true).Sum(oi => oi.ItemPrice)); ;

Typed

new AggregateOperand(new OperandProperty(nameof(Order.OrderItems)), new OperandProperty(nameof(OrderItem.ItemPrice)), Aggregate.Sum, new BinaryOperator(nameof(OrderItem.IsAvailable), true));

String

CriteriaOperator.Parse("[OrderItems][IsAvailable=True].Sum(ItemPrice)");

Test

Input:

Order	OrderItemName	ItemPrice	IsAvailable
Order0
	OrderItem1	10	False
	OrderItem2	20	False
	OrderItem2	30	True
	OrderItem2	40	True

The result: 70