---
schema_version: "1"
id: a4c5e6d70c34a5bdd79d94dc4828b8a2cbff1c248bca4cf7521dab17524951bc
title: varp()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-fn-agg-varp.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-varp.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 40bbba1277c6ceebea42a66d7b4df60b7e24bc6fa97a25cc2468b5ea2361e5f1
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# varp()

Returns the variance of the values in a field. Accepts measure fields as input but not expressions.

## Example - Calculate the Population Variance of Deal Amount

```nolang
q = load "DTC_Opportunity_SAMPLE";
q = group q by all;
q = foreach q generate varp('Amount') as 'var_Amount';
```

**See Also**

- [var()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-var.md)