This activity calculates an aggregate numerical function from a numeric column for selected items in a list and stores the result in a variable.
SharePoint Workflow Designer Phrase
Calculate this function on this field from all items in this list and store result in variable.
Parameters
Parameter | Description |
this function | Name of the aggregate function. Available functions: Count, Sum, Avg, Min, Max, Standard Deviation, Mode. |
this field | Optional. 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. |
All | Optional. List item filter. The filter string supports View Name, View ID, and CAML string (<Where>…</Where>). An empty filter returns all items. |
this list | Source list |
Variable | This activity will place the function result into an output variable (Double). |
Available Functions
Name | Description |
Count | Total number of items. |
Sum | The sum of items. |
Avg | Average of values from the specified column. |
Max | Largest non-null value in the specified column. |
Min | Smallest non-null value in the specified column. |
Standard Deviation | A 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 |
Mode | The mode is the value that occurs most frequently in a data set or probability distribution. Learn more |