# Arithmetic Operators

FuseQL supports the following arithmetic functions:

## Functions
- [abs](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#abs)
  - Calculates the absolute value of a numerical value.
- [ceil](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#ceil)
  - Rounds up a numerical value to the nearest integer.
- [cbrt](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#cbrt)
  - Calculates the cube root of a numerical value.
- [exp](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#exp)
  - Calculates Euler’s number, **e**, raised to the power of a numerical value.
- [expm1](https://docs.kloudfuse.com/platform/3.3.6/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.3.6/fuseql-arithmetic-operators/#exp).
- [floor](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#floor)
  - Rounds down a numerical value to the nearest integer.
- [log](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#log)
  - Calculates the natural logarithm of a numerical value.
- [log10](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#log10)
  - Calculates the base 10 logarithm of a numerical value.
- [round](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#round)
  - Rounds the sample values of a numerical value.
- [sqrt](https://docs.kloudfuse.com/platform/3.3.6/fuseql-arithmetic-operators/#sqrt)
  - Calculates the square root of a numerical value.

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

**Syntax**
```code
| 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.3.6/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
```