---
schema_version: "1"
id: e5fd26149d7b33ed47e8827a2fa633f6f127571e5e10807cb81bee17f1bf3a81
title: abs({n})
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-math-abs.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-math-abs.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 52004770ec1c50190936f638b2d8940c4a6f9d7762440d75ef3645ec2124cf10
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# abs({n})

Returns the absolute number of _n_ as a numeric value. _n_ can be any real numeric value in the range of -1.797e308 \<= _n_ \<= 1.797e308.

`abs({n})` takes the following syntax.

```nolang
SELECT abs(COLUMN_NAME) as ALIASNAME
FROM DATASET;
```

## Example

This example takes the absolute value of the Profit field.

```nolang
SELECT abs(Profit) as absProfit FROM Superstore
LIMIT 1;
```

| absProfit |
| --------- |
| 41.9136   |