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 the parameter two 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 Topics Link IconRelated Topics