# Arithmetic operators

FuseQL supports the following arithmetic functions:

- [abs](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#abs): Calculates the absolute value of a numerical value.
- [ceil](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#ceil): Rounds up a numerical value to the nearest integer.
- [cbrt](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#cbrt): Calculates the cube root of a numerical value.
- [exp](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#exp): Calculates Euler’s number, **e**, raised to the power of a numerical value.
- [expm1](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#expm1): Calculates `exp(<number>) − 1` for a numerical value; compensates for round-off errors in [exp](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#exp).
- [floor](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#floor): Rounds down a numerical value to the nearest integer.
- [log](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#log): Calculates the natural logarithm of a numerical value.
- [log10](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#log10): Calculates the base 10 logarithm of a numerical value.
- [round](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#round): Rounds the sample values of a numerical value.
- [sqrt](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#sqrt): Calculates the square root of a numerical value.

## 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](https://docs.kloudfuse.com/platform/3.4.0.p1/fuseql-arithmetic-operators/#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
```