# Calculate aggregate function

This activity 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 in *this list* and store result in *variable*

**Parameters**

Parameter |
Description |
---|---|

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 Count function. |

All | Optional. List item filter. The filter string supports View Name, View ID and CAML string (<Where>...</Where>). Empty filter returns all items. |

this list | Source list |

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 variance http://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 |