Re: [WebERP-developers] Float accuracy problem

[Pak R. <pak...@gm...>]

Hi all:

I think some of the issues come from the way we do some calculations, more
than Turing's machines restrictions on floating numbers :-)

As a simplified example: In some cases we calculate:
X = A / B;

in some other cases we maybe do:
C = B / A;
....
....
X = 1 / C;

Even if mathematically it's equivalent, a computer can produce a slightly
different result

We have some examples of this on multicurrency calculations (translating
from home to foreign or viceversa). This links to a "hot topic" we
discussed last year, as we do the same calculations over and over in
different scripts with slightly different code. But I don't want to
introduce more variables to the issue. Let's focus on precision, but
probably we need to have this in mind, if we look for a consistent solution.


Regards,
Ricard

2015-01-09 9:01 GMT+08:00 ExsonQu <hex...@gm...>:

> *Dear all,*
>
>          I've searched more data about this.
>
>          Since we use double type almost everywhere, only sometime things
> go
> wrong. And about the precision math, mysql manual has explained that:
>
> http://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
>           Numbers are used with their exact value as given when possible.
>
>           The simple and effective solution may just find out those places
> where 'exact values used not possible'.
>
>           Best regards!
>
>           Exson
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Float-accuracy-problem-tp4657899p4657957.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>