---
schema_version: "1"
id: ff8258d113ac778d95328265b11b9dd011f98255af2f97d50aebe1feec4378dc
title: var()
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-var.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-var.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 476237585ef2016e71828d16acf28b495acb05201df586ac923f6d557a02d6df
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# var()

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

## Example - Calculate the Variance of Deal Amount

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

**See Also**

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