`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.

1SELECT abs(COLUMN_NAME) as ALIASNAME
2FROM DATASET;

Example

This example takes the absolute value of the Profit field.

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

absProfit
41.9136