ROUND

Rounds a numeric expression to the nearest value, depending on the number of specified decimals.

Reporting Areas(s)

General

Required Parameters

1. Numeric Expression to round (i.e. rgceus, [coenrolled/comax])
2. Numeric return value: the number of decimals to return (i.e. 2,-2)

Optional Parameters

None

Example(s)

ROUND(rgceus,0) rounds the rgceus to the nearest whole number, i.e. 3, if the rgceus field is 2.75

ROUND(coenrolled/comax,2) rounds the expression to two decimals, i.e. 75.22

ROUND(12345.22,-2) returns 12300

Notes

Standard FoxPro function

Entering a negative number in Parameter #2 will return a whole number containing the specified number of zeros to the left of the decimal point (i.e. -2 will return 12300 if the number is 12345.67

Related Functions

FULLCENT
VAL