IMPORTANT! About rounded values
Hi!
Please, help me!
I noticed that, with an "Extended" datafield type (or Currency, etc...) if I
set "DisplayFormat" to 0.00 (2 decimals) the round is incorrect in some
cases:
For example:
Field value = 0,075
If I set DisplayFormat to 0.00, the result would be 0,08
BUT IT IS 0,07!!!!
But with other values, like 2,075 it is correct, and it prints 2,08!!
WHY?
In Spain the "rounds" are made this way!
Where can I change this in the RB source? I have been looking for it but I
don't know where to change this!
Forive my English, please.
Please, help me!
I noticed that, with an "Extended" datafield type (or Currency, etc...) if I
set "DisplayFormat" to 0.00 (2 decimals) the round is incorrect in some
cases:
For example:
Field value = 0,075
If I set DisplayFormat to 0.00, the result would be 0,08
BUT IT IS 0,07!!!!
But with other values, like 2,075 it is correct, and it prints 2,08!!
WHY?
In Spain the "rounds" are made this way!
Where can I change this in the RB source? I have been looking for it but I
don't know where to change this!
Forive my English, please.
This discussion has been closed.
Comments
correctly to 0.08. However we have run into it before (see Rounding Errors
with Currency Totals, 5/15/2001). Currency values are formatted in
ReportBuilder using the FormatFloat function. You can create a simple Delphi
application and attempt to pass the value to that function to see if the
error reproduces itself.
--
Cheers,
Alexander Kramnik
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com