Variable-Problem
Hello,
I have a DB-field with the Value 445.995. This will be printed with the
mask '#,0.00;-#,0.00'. The result is 446,00 and I like it.
Now I have a Variable with the following calc:
Gefall['GF_BSUMME'] - Gefall['GF_USUMME'];
The Value will also be 445.995. When I use the same mask I will get
445.99 and thats wrong. Only If I add a line with
Value := Round(Value);
I get the correct printing.
What can I do it. It is very difficult to explain this to our
customers.
Gruß aus den Bergen
Günter
I have a DB-field with the Value 445.995. This will be printed with the
mask '#,0.00;-#,0.00'. The result is 446,00 and I like it.
Now I have a Variable with the following calc:
Gefall['GF_BSUMME'] - Gefall['GF_USUMME'];
The Value will also be 445.995. When I use the same mask I will get
445.99 and thats wrong. Only If I add a line with
Value := Round(Value);
I get the correct printing.
What can I do it. It is very difficult to explain this to our
customers.
Gruß aus den Bergen
Günter
This discussion has been closed.
Comments
If I remember right, you are using Advantage, then you can use the SQL
function 'Round' - no IEEE rounding!.
In your given example, the result, when using the picture mask given, isn't
wrong - 445.99 is ok!
regards,
Chris Ueberall;
and there is no similar built-in function?
I personally don't use any calculating for values which must be exact in the
lowest bit - to avoid any rounding issue on reporting. Isn't it possible for
you to do the calculating before reporting?
regards,
Chris Ueberall;