Calculate aggregate function

⌘K

Calculate aggregate function

This activity calculates an aggregate numerical function from a numeric column for selected items in a list and stores the result in a variable.

calculate_aggregate_function_1
SharePoint Workflow Designer Phrase

Calculate this function on this field from all items in this list and store result in variable.

Parameters

ParameterDescription
this functionName of the aggregate function. Available functions: Count, Sum, Avg, Min, Max, Standard Deviation, Mode.
this fieldOptional. Numerical field on which the mathematical function will be performed. Can be specified by field display name, unique ID (GUID), or field index (int). Not required for the Count function.
AllOptional. List item filter. The filter string supports View Name, View ID, and CAML string (<Where>…</Where>). An empty filter returns all items.
this listSource list
VariableThis activity will place the function result into an output variable (Double).

Available Functions

NameDescription
CountTotal number of items.
SumThe sum of items.
AvgAverage of values from the specified column.
MaxLargest non-null value in the specified column.
MinSmallest non-null value in the specified column.
Standard DeviationA measure of variation in a distribution of values from the specified column, equal to the square root of the arithmetic mean of the squares of the deviations from the arithmetic mean; the square root of the variance. Learn more
ModeThe mode is the value that occurs most frequently in a data set or probability distribution. Learn more

How can we help?