---
schema_version: "1"
id: 37dbb083f13067c6d5b9149489477cb08fcc7bb7f08db62653c7a6b5e69ab508
title: regr_r2()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-aggregate-regr-r2.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-regr-r2.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: b1f5a9b39aa68ba4e20777a3125d2e56c12565735354e5cc0bc038ac13e1b006
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# regr_r2()

Returns the R-squared, or goodness-of-fit value for a regression.

`regr_r2()` follows this syntax.

```nolang
SELECT regr_r2(FIELD1, FIELD2)
FROM DATASET;
```