Function: Round

Description

Rounds number to a specified number of places to the right (or left) of the decimal point.

Syntax

Round(number,decimals)

Arguments

number is the value to be rounded. The number can be a constant, a numeric field, an expression that results in a number or a function that returns a number.

decimals is the position of the digit to round relative to the decimal point. Positive numbers round to the right of the decimal point, negative numbers to the left. Zero rounds a number to an integer. This value can be a constant, a numeric field, an expression that results in a number or a function that returns a number.

Return value

This function returns a number.

Calculated field examples

If the Unit_price field contained the value 29.85, the following calculated field expression would return the number 29.9: Round(Unit_price,1)

If the Unit_price field contained the value 1229.93, the following calculated field expression would return the number 1200: Round(Unit_price,-2)

Filter/Find example

Records with a Unit_price field value of 34.70 or 35.02 can be selected or found using the expression: Round(Unit_price,0)=35