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
© 2024 Altair Engineering Inc. All Rights Reserved.