
WHY MY DECIMAL POINT GOING LIKE THIS?
WHY MY DECIMAL POINT GOING LIKE THIS?
Written by msbz288@streamyx.com 26/08/15 at 02:09:04 Dataease [{8}]FIVEHow to change decimal symbol and grouping (thousand separator) in DataEase 8
We can't see anything wrong, but if you are thinking of the decimal symbol and the digit grouping symbol (thousands separator) then this s governed by your windows settings.
You find them under Control Panel, Region, Customize Format.
Re:How to change decimal symbol and grouping (thousand separator) in DataEase 8
It looks like a rounding problem. The system has not added the 0.01 to the running total.
Re:Re:How to change decimal symbol and grouping (thousand separator) in DataEase 8
The "problem" here is that in calculations DataEase always work with FLOAT so individually both of these two numbers is rounded up but when added the rounding up of the sum is the same as the previous one.
If you want to avoid this convert the numbers to text and then back to number and they will "loose" the extra decimals.
The total of the report etc will be correct however.
Penny for your Thoughts ! Re:Re:Re:How to change decimal symbol and grouping (thousand separator) in DataEase 8
This site had a series of tools for rounding, but it was for DE 5.5
http://www.computerwizardonline.com/wizutils1.htm
There is also a discussion in the Ffenics Technical forum which is worth reading and it mentions DE as it behaves in the same way.
http://www.ffenics.net/viewtopic.php?p=10173&sid=c...
There is much discussion about this, google "how to solve floating point rounding"
Access also has this problem
http://allenbrowne.com/round.html
and there is a solution by Ken Getz ( an Access guru and author )
http://access.mvps.org/access/modules/mdl0054.htm
All this for a Penny !