topic Random Rounding Error?? in State & Local Government Questions https://community.esri.com/t5/state-local-government-questions/random-rounding-error/m-p/562829#M3639 <HTML><HEAD></HEAD><BODY><SPAN>I have a field that is double with no defined precision or scale and populated with real numbers.</SPAN><BR /><SPAN>I create a new field, same format, and use field calc to subtract each number by .01</SPAN><BR /><SPAN>I create another field, same format, use field calc to subtract new number from original.</SPAN><BR /><SPAN>I get results, seemingly randomly, that range from .01 to .009xx.</SPAN><BR /><SPAN>WHY?</SPAN><BR /><SPAN>ver 10.1 build 3143</SPAN></BODY></HTML> Fri, 18 Apr 2014 18:39:46 GMT AnthonyGalante 2014-04-18T18:39:46Z Random Rounding Error?? https://community.esri.com/t5/state-local-government-questions/random-rounding-error/m-p/562829#M3639 <HTML><HEAD></HEAD><BODY><SPAN>I have a field that is double with no defined precision or scale and populated with real numbers.</SPAN><BR /><SPAN>I create a new field, same format, and use field calc to subtract each number by .01</SPAN><BR /><SPAN>I create another field, same format, use field calc to subtract new number from original.</SPAN><BR /><SPAN>I get results, seemingly randomly, that range from .01 to .009xx.</SPAN><BR /><SPAN>WHY?</SPAN><BR /><SPAN>ver 10.1 build 3143</SPAN></BODY></HTML> Fri, 18 Apr 2014 18:39:46 GMT https://community.esri.com/t5/state-local-government-questions/random-rounding-error/m-p/562829#M3639 AnthonyGalante 2014-04-18T18:39:46Z Re: Random Rounding Error?? https://community.esri.com/t5/state-local-government-questions/random-rounding-error/m-p/562830#M3640 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I have a field that is double with no defined precision or scale and populated with real numbers.<BR />I create a new field, same format, and use field calc to subtract each number by .01<BR />I create another field, same format, use field calc to subtract new number from original.<BR />I get results, seemingly randomly, that range from .01 to .009xx.<BR />WHY?<BR />ver 10.1 build 3143</BLOCKQUOTE><BR /><BR /><SPAN>Hello, </SPAN><BR /><BR /><SPAN>You may want to post this question in the GeoDatabase forum:&nbsp; </SPAN><A href="http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE">http://forums.arcgis.com/forums/32-Geodatabase-amp-ArcSDE</A><BR /><BR /><SPAN>Thanks, </SPAN><BR /><BR /><SPAN>Chris - Solutions</SPAN></BODY></HTML> Mon, 28 Apr 2014 17:58:14 GMT https://community.esri.com/t5/state-local-government-questions/random-rounding-error/m-p/562830#M3640 ChrisBuscaglia 2014-04-28T17:58:14Z