Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Arithmetic Functions

Round Function

Round Function

Description:
Round a number either up or down to a specified number of decimal places. The value is rounded up (away from zero) if the digit after the last significant decimal place is 6-9 (positive values) or 6-9 (negative values).
The value is rounded down (towards zero) if the digit after the last significant decimal place is 0-4 (positive values) or 0-5 (negative values).
If the digit after the last significant decimal place is 5 the value is rounded to the nearest even number. If the last digit before the 5 is an even number it will be rounded down, if the last digit before 5 is an odd number it will be rounded up.
Returns:
Number
Parameters:
Parameter
Data Type
Description
1
Number
The number to be rounded.
2
Whole Number
The decimal precision.
Examples:
When using functions inside a field, remember the field brackets:
{Round(VariableName)}
Expression
Result
Round( 0.124, 2 )
0.12
Round( 0.125, 2 )
0.12
Round( -0.126, 2 )
-0.13
Round( 0.135, 2 )
0.14

This article applies to:

  • Product: Contract Express