# Round Up (Expression Function)

## Purpose

The Round Up function (ROUND_UP) rounds a number up or down to a certain number of decimal places

## Parameters

The Round Up function has two parameters, one of which is required:

### Value

Allowed Inputs: field value or number

The first required parameter is the number that will be rounded. Either use the use the Query Builder to choose a field that contains the value or use type a value to enter a number.

### Precision

Allowed Inputs: field value or a number

The second optional parameter of the Round Up function is the number of decimal places to round to. If no value is provided then 0 will be used and the value will be rounded up to the nearest integer value. If the number is positive then the rounding will include that number of digits after the decimal. If the number is negative then the number will round with that many zeros on the left of the decimal.

## Output

The output of the Round Up function is a number representing the value rounded to the nearest decimal place.

## Example

For example ROUND_UP(-5.56) would result in -5 and ROUND_UP(5.56) will result in 6. Using positive precision for example ROUND_UP(5.33,1) would result in 5.4 and using negative precision ROUND_UP(12.33,-1) would result in 20.

expression function - round up.txt · Last modified: 2016/09/14 14:19 (external edit)