# Arithmetic Operators

FuseQL supports the following arithmetic functions:

## abs

Calculates the absolute value of a numerical value.

**Syntax**

```console
| abs(<number>) as <alias>
```

**Example**

The following example returns A with a value of `42`.

```console
| abs(-42) as A
```

## ceil

Rounds up a numerical value to the nearest integer.

**Syntax**

```console
| ceil(<number>) as <alias>
```

**Example**

The following example returns C with a value of `4`.

```console
| ceil(3.14) as C
```

## cbrt

Calculates the cube root of a numerical value.

**Syntax**

```console
| cubeRoot(<number>) as <alias>
```

**Example**

The following example returns R with a value of `3`.

```console
| cubeRoot(27) as R
```

## exp

Calculates Euler’s number **e** raised to the power of a numerical value.

**Syntax**

```console
| exp(<number>) as <alias>
```

**Example**

The following example returns E with a value of `2.71828`.

```console
| exp(1) as E
```

## expm1

Calculates `exp(<number>) − 1` for a numerical value; compensates for round-off errors in exp.

**Syntax**

```console
| expm1(<number>) as <alias>
```

**Example**

The following example returns M with a value of `1.71828`.

```console
| expm1(1) as M
```

## floor

Rounds down a numerical value to the nearest integer.

**Syntax**

```console
| floor(<number>) as <alias>
```

**Example**

The following example returns F with a value of `3`.

```console
| floor(3.14) as F
```

## log

Calculates the natural logarithm of a numerical value.

**Syntax**

```console
| log(<number>) as <alias>
```

**Example**

The following example returns L with a value of `2.30258`.

```console
| log(10) as L
```

## log10

Calculates the base 10 logarithm of a numerical value.

**Syntax**

```console
| log10(<number>) as <alias>
```

**Example**

The following example returns L with a value of `1`.

```console
| log10(10) as L
```

## round

Rounds the sample values of a numerical value.

**Syntax**

```console
| round(<number>) as <alias>
```

**Example**

The following example returns R with a value of `4`.

```console
| round(3.5) as R
```

## sqrt

Calculates the square root of a numerical value.

**Syntax**

```console
| sqrt(<number>) as <alias>
```

**Examples**

The following example returns S with a value of `4`.

```console
| sqrt(16) as S
```