---
title: Math functions
slug: math-functions
description: Perform calculations, rounding, and number formatting
image: https://archbee-image-uploads.s3.amazonaws.com/oAyFj2GHlBeBVWF5OAir2/2f2VgmFlXtyvPo1BMHupJ_domino-zoomin-purple-a-1.png
docTags: 
createdAt: 2025-02-03T13:29:15.598Z
---

Use a math function to apply mathematical operations to data. For example, math functions let you get an average of an array, round a value up or down, or change the format of a number (1 000 000 to 1,000,000 or 1.000.000). Below is a list of supported math functions and a brief description of each one.

## abs 

**abs (number)**

Returns the absolute value of an integer.

```none
abs( -5 ) = 5
```

```none
abs( 5 ) = 5
```

```none
abs( 0 ) = 0
```

```none
abs( -3.7 ) = 3.7
```

## average

**average (\[array of values]) average(value1; \[value2], ...)**

Returns the average value of the numeric values in a specific array, or the average value of numerical values entered individually.

## ceil

**ceil (number)**

Returns the smallest integer greater than or equal to a specified number.

```none
ceil( 1.2 ) = 2
```

```none
ceil ( 4 ) = 4
```

## floor

**floor (number)**

Returns the largest integer less than or equal to a specified number.

```none
floor( 1.2 ) = 1
```

```none
floor( 1.9 ) = 1
```

```none
floor( 4 ) = 4
```

## formatNumber

**formatNumber (number; decimalPOINTS; \[decimalSeparator]; \[thousandsSeparator])**

Returns a number in the requested format. Decimal point is \`,\` by default, Thousands separator is \`.\` by default.

```none
formatNumber( 123456789 ; 3 ; , ; . ) = 123.456.789,000
```

## max

**max (\[array of values]), max(value1;value2; ...)**

Returns the largest number in a specified array, or the largest number among numbers entered individually.

## median

**median (\[array of values])**

Returns the median of the values in a specified array, or the median of numbers entered individually.

```none
median( 3; 5; 7 ) = 5
```

```none
median( 2; 3; 5; 8 ) = 4
```

```none
median( 2.5; 3.5; 2; 4.5; 1 ) = 2.5
```

## min

**min (\[array of values]), min(value1;value2; ...)**

Returns the smallest number in a specified array, or the smallest number among numbers entered individually.

## parseNumber

**parseNumber (number; decimal separator)**

Parses a string with a number and returns the number.

Example: `parseNumber(` 1 756,456 `;` , `)`

## round

**round (number)**

Rounds a numeric value to the nearest integer.

```none
round( 1.2 ) = 1
```

```none
round( 1.5 ) = 2
```

```none
round( 1.7 ) = 2
```

```none
round( 2 ) = 2
```

## stdevP

**stdevP (\[array of values])**

Returns the standard deviation of a specified array of population values, or the standard deviation of numbers entered individually.

```none
stdevP( 1; 2; 3; 4; 5) = 1.4142135623730951
```

```none
stdevP( {{array}} )
```

## stdevS

**stdevS (\[array of values])**

Returns the standard deviation of a specified array of sample values, or the standard deviation of numbers entered individually.

```none
stdevS( 1; 2; 3; 4; 5) = 1.5811388300841898
```

```none
stdevS( {{array}} )
```

## sum

**sum (\[array of values]), sum(value1;value2; ...)**

Returns the sum of the values in a specified array, or the sum of numbers entered individually.

## trunc

**trunc (number)**

Truncates a number to an integer by removing the fractional part of the number.

```none
trunc( 3.789) = 3
```

```none
trunc( 3.789; 2) = 3.78
```

```none
trunc( -3.789; 2 ) = -3.7
```

```none
trunc( 123.456; -2 ) = 100
```