Calculate aggregate function
This activity finds list by url and calculates aggregate numerical function from a numeric column for selected item in list and store result in variable.
SharePoint Workflow Designer Phrase#
Calculate this function on this field from all items at list url and store result in variable
Parameters#
Input parameters
| Parameter | Description | Example |
| this function | Name of the aggregate function. | Available Functions: Count, Avg, Min, Max, Standard Deviation, Mode. |
| this field | Optional. Numerical field on which mathematical function will be performed. Field display name. Field unique ID (Guid). Field index (int).Not required for Countfunction. | FieldName 23{F3DF15C2-F16E-4FD3-85F6-7EE05227A079} |
| All | Optional. List item filter. The filter string supports View Name, View ID andCAML string (<Where>...</Where>). | <View Scope='RecursiveAll'><Query><Where><Contains><FieldRef Name='FileLeafRef' /> |
| Empty filter returns all items. | <Value Type='File'> .docx </Value></Contains></Where><OrderBy><FieldRef Name='ID' /></OrderBy></Query></View> | |
| list identifier | List name, list base template, guid or list url | Ex: http://mysharepoint/MyDocs/Shared%20Documents Ex:http://mysharepoint/Lists/List%20with%20Approve |
| Variable | This activity will place 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 | Smallest non-null value in the specified column |
| Min | Largest non-null value in the specified column |
| Standard Deviation | A measure of the 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 variancehttp://en.wikipedia.org/wiki/Standard_deviation |
| Mode | The mode is the value that occurs the most frequently in a data set or a probability distribution.http://en.wikipedia.org/wiki/Mode_%28statistics%29 |
Example
