Progress
Report Builder
User’s Guide
TRUNCATE
Truncates a numeric value to a specified number of decimal places, returning a numeric value.
SYNTAX
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.
EXAMPLETo truncate a field Numbers to two decimal places, create a calculated field containing this expression:
Sample data:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |