# Using Statistical Functions

You can choose the following statistical functions in a binding:

- Min
- Max
- Average
- Mode
- Median
- Variance
- Standard Deviation

These functions accept a list of fields and perform the function on the provided list of field values. The following rules apply when using these functions:

- There is no support for nested functions. This means that these functions may not contain any other nested functions inside the parenthesis.
- When a field has a blank/null value it is not considered in the equation
- When a multi-select element (Checkbox or Drop Down with multi-select enabled) is used, each selection is considered a separate value. For example if you had a checkbox group with 5 fields and the user selects 3 of the options. The average would be calculated based on those 3 values.
- Standard Deviation and Variance are calculated using the total population
**Do not use a Field Mask**on a field that uses a binding to calculate a total using these methods. Instead, use the numberFormat() and/or currentFormat() wildcard modifier to format the results. Masks are intended to 'mask' data entry and can have unexpected results when used to format bound values.

Have more questions? Submit a request

Please sign in to leave a comment.

## 0 Comments