# Numeric functions - Cloud

## Talend Data Shaping Language Reference Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Data Shaping Language
Content
Design and Development

The following functions can be used to perform operations on numeric values.

Note: The functions `exp`, `ln`, `log`, `max` and `min` are only available in Talend Cloud Pipeline Designer.
Function Description Arguments Example
`abs` Returns the absolute value of a number. Numeric value. Expression: `abs(-3)`

Result: `3`

`ceil` Returns the smallest integer greater than the input value. If the input value is an integer, the result is the same as the input. Numeric value. Expression: `ceil(5.1)`

Result: `6.0`

exp Returns the constant `e` to the power of the first argument. Numeric value. Expression: `exp(2)`

Result: `7.38905609893065`

`floor` Returns the largest integer smaller than the input value. If the input value is an integer, the result is the same as the input. Numeric value. Expression: `floor(42.9)`

Result: `42.0`

ln Returns the logarithm of the first argument to the base of the constant `e`. Numeric value. Expression: `ln(15)`

Result: `2.70805020110221`

log Returns the logarithm of the first argument to the base of `10`. Numeric value. Expression: `log(25)`

Result: `1.3979400086720377`

min Returns the smallest of two numeric values.
1. First numeric value.
2. Second numeric value.
Expression: `min(1.5, 60)`

Result: `1.5`

max Returns the largest of two numeric values.
1. First numeric value.
2. Second numeric value.
Expression: `max(1752,687)`

Result: `1752`

`power` Returns the first argument to the power of the second argument.
1. Numeric value to multiply.
2. Numeric value to use as exponent.
Expression: `power(5,3)`

Result: `125.0`

`round` Returns the integer closest to the input value. Numeric value. Expression: `round(45.6)`

Result: `46`

`sign` Returns `1.0` if the input value is a positive number and `-1.0` if the input is a negative number. Numeric value. Expression: `sign(15)`

Result: `1.0`

`sqrt` Returns the square root of the argument. Numeric value. Expression: `sqrt(25)`

Result: `5.0`