ROUND ​
Rounds a numeric expression to the nearest value, depending on the number of specified decimals.
Reporting Areas(s) ​
General
Required Parameters ​
- Numeric Expression to round (i.e. rgceus, [coenrolled/comax])
- 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