Truncate PowerScript function
Description
Truncates a number to the specified number of decimal places.
Syntax
|
1 |
<span>Truncate</span> ( <span>x</span>, <span>n</span> ) |
|
Argument |
Description |
|---|---|
|
x |
The number you want to truncate. |
|
n |
The number of decimal places to which |
Return Values
Decimal. Returns the result of the truncation
if it succeeds and null if it fails or if any
argument is null.
Using Truncate on a computed field
A real number loaded into a floating point register (used
for calculation) is represented as precisely as the binary storage
will permit. For example, the real number displayed as 2.07 is actually
stored as 2.06999999999999999999999997.
Truncating such a number may not give the expected result.
To avoid this problem, you can change the initial real datatype
to long, integer, or decimal, or you can append a constant in the
truncate argument: Truncate (x + 0.0000001, n )
Examples
This statement returns 9.2:
|
1 |
<span>Truncate</span>(9.22, 1) |
This statement returns 9.2:
|
1 |
<span>Truncate</span>(9.28, 1) |
This statement returns 9:
|
1 |
<span>Truncate</span>(9.9, 0) |
This statement returns –9.2:
|
1 |
<span>Truncate</span>(-9.29, 1) |