# Arithmetic operators

FuseQL supports the following arithmetic functions for performing mathematical operations in queries:

## abs
Calculates the absolute value of a numerical value.

### Syntax
```none
| 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>
```

### Example
The following example returns S with a value of `4`.
```console
| sqrt(16) as S
```