|
Extracts a specified part of a number and rounds the result.
|
|
Syntax:
|
Round(number, whole, decimal)
|
|
Parameters:
|
number: The number subjected to the operation.
|
|
|
whole: The number of digits to be extracted from the integer part of number. Magic xpa counts the digits left from the decimal separator.
|
|
|
decimal: The number of digits to be extracted from the decimal part of number. Magic xpa counts the digits right from the decimal separator. When the decimal is a negative number, the numeric expression is rounded to the left side of the decimal point.
|
|
Returns:
|
Rounded number
|
|
Example:
|
Round(345.995,2,2) = 46.00
Round(657.37,3,-1) = 660.00
|
|
See also:
|
DbRound
Fix
The Online and Rich Client Samples projects (program NM06 and RNM06)
|
