Returns the sum of a specified member or expression across a collection.
Syntax 1
|
|
Returns the sum of a specified member or expression across a collection. |
|
|
Sum(collection, field) |
|
|
Arguments: |
|
|
|
collection |
Collection - A collection. |
|
|
|
field |
Field - The field to sum. |
Syntax 2
|
|
Returns the sum of a specified member or expression across a collection. |
|
|
Sum(collection, expression) |
|
|
Arguments: |
|
|
|
collection |
Collection - A collection. |
|
|
|
expression |
Numeric - An expression that resolves to a number. |
Syntax 3
|
|
Returns the sum of a specified member or expression across a collection. |
|
|
Sum(collection, field, filter) |
|
|
Arguments: |
|
|
|
collection |
Collection - A collection. |
|
|
|
field |
Field - The field to sum. |
|
|
|
filter |
FilterExpression - Filter criteria. Only collection members that match this criteria will be considered. |
Syntax 4
|
|
Returns the sum of a specified member or expression across a collection. |
|
|
Sum(collection, expression, filter) |
|
|
Arguments: |
|
|
|
collection |
Collection - A collection. |
|
|
|
expression |
Numeric - An expression that resolves to a number. |
|
|
|
filter |
FilterExpression - Filter criteria. Only collection members that match this criteria will be considered. |
Remarks
- Arguments after the collection argument are evaluated in the context of a collection member.
- Example: Sum(Vehicles, BI_PD.Premium, Year=1999) returns 400540.
Comments
0 comments
Article is closed for comments.