>Hi all
>
>I understand that using Currency field may need to calculation inaccuracy without using MTON() function to first convert it into numeric. I would appreciate if you could advise what then are the benefits of using Currency field instead of Numeric field when designing database.
>
>Thanks & Best Regards
In the case in which you want that the result of an algebraic sum
doesn't depend on the order of the addends.
clear
a=1.0000000
b=0.1000000
c=0.2000000
? (b+c-b-c)*a=(b-b+c-c)*a
? ROUND((b+c-b-c)*a,7)=ROUND((b-b+c-c)*a,7)