# Arithmetic operators

FuseQL supports the following arithmetic functions:

### Functions

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

## Details of Functions

### abs
**Calculates the absolute value of a numerical value.**  
**Syntax**
```none
| abs(<number>) as <alias>
```
**Example**
```console
| abs(-42) as A
```

### ceil
**Rounds up a numerical value to the nearest integer.**  
**Syntax**
```console
| ceil(<number>) as <alias>
```
**Example**
```console
| ceil(3.14) as C
```

### cbrt
**Calculates the cube root of a numerical value.**  
**Syntax**
```console
| cubeRoot(<number>) as <alias>
```
**Example**
```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**
```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/4.0.2/query-languages/fuseql/arithmetic-operators/#exp).**  
**Syntax**
```console
| expm1(<number>) as <alias>
```
**Example**
```console
| expm1(1) as M
```

### floor
**Rounds down a numerical value to the nearest integer.**  
**Syntax**
```console
| floor(<number>) as <alias>
```
**Example**
```console
| floor(3.14) as F
```

### log
**Calculates the natural logarithm of a numerical value.**  
**Syntax**
```console
| log(<number>) as <alias>
```
**Example**
```console
| log(10) as L
```

### log10
**Calculates the base 10 logarithm of a numerical value.**  
**Syntax**
```console
| log10(<number>) as <alias>
```
**Example**
```console
| log10(10) as L
```

### round
**Rounds the sample values of a numerical value.**  
**Syntax**
```console
| round(<number>) as <alias>
```
**Example**
```console
| round(3.5) as R
```

### sqrt
**Calculates the square root of a numerical value.**  
**Syntax**
```console
| sqrt(<number>) as <alias>
```
**Example**
```console
| sqrt(16) as S
```