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)