Description | The VAR() function calculates the variance of a specified numeric field within a range or partition. This is useful for measuring the spread or dispersion of the data. |
Syntax | STDDEV( |
Output | numeric |
Variables
number: the numeric field on which to calculate the variance.
Example
VAR(Value) Over (Partition by Group)
ID | Group | Value | VAR |
1 | A | 10 | 25 |
2 | A | 20 | 25 |
3 | A | 15 | 25 |
4 | B | 30 | 50 |
5 | B | 40 | 50 |