Skip to main content

Celonis Product Documentation

Math functions

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 (number)

Returns the absolute value of an integer.

abs( -5 )

= 5

abs( 5 )

= 5

abs( 0 )

= 0

abs( -3.7 )

= 3.7

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 (number)

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

ceil( 1.2 )

= 2

ceil( 4 )

= 4

floor (number)

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

floor( 1.2 )

= 1

floor( 1.9 )

= 1

floor( 4 )

= 4

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

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

formatNumber( 123456789 ; 3 ; , ; . )

= 123.456.789,000

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

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

median ([array of values])

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

median( 3; 5; 7 )

= 5

median( 2; 3; 5; 8 )

= 4

median( 2.5; 3.5; 2; 4.5; 1 )

= 2.5

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

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

parseNumber (number; decimal separator)

Parses a string with a number and returns the number.

Example: parseNumber( 1 756,456 ; , )

round (number)

Rounds a numeric value to the nearest integer.

round( 1.2 )

= 1

round( 1.5 )

= 2

round( 1.7 )

= 2

round( 2 )

= 2

stdevP ([array of values])

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

stdevP( 1; 2; 3; 4; 5)

= 1.4142135623730951

stdevP( {{array}} )

stdevS ([array of values])

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

stdevS( 1; 2; 3; 4; 5)

= 1.5811388300841898

stdevS( {{array}} )

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 (number)

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

trunc( 3.789)

= 3

trunc( 3.789; 2)

= 3.78

trunc( -3.789; 2 )

= -3.7

trunc( 123.456; -2 )

= 100