| Parameter | Type | Description |
|---|---|---|
value | decimal, double | The values from which to take the variance. |
Returns: decimal
Example
query:
SELECT VARIANCE(sales_pipeline.close_value)
FROM sales_pipeline
WHERE deal_stage = "Won"result:
| variance |
|---|
| 6,472,873.48 |
VARIANCE
Population Variance.