Kbase 17502: Report Builder ROUND bug workaround.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Report Builder ROUND bug workaround.
There is a bug in Report Builder (Bug Number 95-11-02-060) where the
ROUND function does not always round up when it is supposed to.
Example:
12.435 should round to 12.44 (correct), but instead rounds to
12.43 (incorrect).
The possible workaround for this problem is as follows.
In Report Builder, create a User Defined Function (UDF) with the
following equations:
x = x * 100
x = x + .5
x = int(x)
x = x / 100
This is all where "x" equals the value that you are trying to round.
The result is that you will have rounded accuracy in the first 2
decimal places. This could obviously be altered for greater degrees
of accuracy.
Progress Software Technical Support Note # 17502