Progress
Report Builder
User’s Guide


TRUNCATE

Truncates a numeric value to a specified number of decimal places, returning a numeric value.

SYNTAX

TRUNCATE ( expression , decimal-places ) 

expression

A numeric value (a constant, field name, or expression that results in a numeric value) that you want to truncate.

decimal-places

A positive or negative integer expression that indicates the number of decimal places you want to result from truncating the expression. A decimal-places of zero returns the same value as the INTEGER function.

EXAMPLE

To truncate a field Numbers to two decimal places, create a calculated field containing this expression:

TRUNCATE(Numbers, 2) 

Sample data:

Numbers        TRUNCATE(Numbers, 2)
 25.3342               25.33
  2.4695                2.46
-56.2136              -56.21 


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