Easy to Create, Easy to Change - Easy to use!


WHY MY DECIMAL POINT GOING LIKE THIS?


Started by msbz288@streamyx.com
Search
You will need to Sign In to be able to add or comment on the forum!

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}]FIVE

How 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.

Written by DataEase 26/08/15 at 09:28:17 Dataease [{8}]FIVE

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.

Written by Kensington 26/08/15 at 09:52:12 Dataease [{8}]FIVE

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.

Written by DataEase 26/08/15 at 11:00:23 Dataease [{8}]FIVE

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 !

Written by Kensington 27/08/15 at 09:23:32 Dataease [{8}]FIVE