Progress
Report Builder
User’s Guide


ROUND

Rounds a numeric value to a specified number of places after the decimal point.

SYNTAX

ROUND ( expression , precision ) 

expression

A numeric value (a constant, field name, or expression that results in a numeric value). A negative value rounds to the left of the decimal point.

precision

A positive or negative integer expression whose value is the number of places you want in the decimal result of the ROUND function.

EXAMPLE

To round numbers in a numeric field Numbers to 0 decimal places, create the field:

ROUND(Numbers,0) 

Sample data:

Numbers        ROUND(Numbers,0)
23453.3455     23453 (rounds down)
98789.7656     98790 (rounds up) 

To round numbers in a numeric field Numbers to the nearest multiple of 10, create the field:

ROUND(Numbers,-1) 

To round numbers in Numbers to the nearest million, create the field:

ROUND(Numbers,-6) 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095