Sqr() function produced incorrect results in ArcMap.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM006246
Submitted
January 23, 2007
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.1
Status
Non-Reproducible
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
Using 9.1, if you create 4 new fields and separate the Calculator equation, the correct results can be achieved.In the 1st field, calculate: ([X_beforeOffset]- [X_afterOffset])*([X_beforeOffset]- [X_afterOffset])In the 2nd field, calculate: ([Y_beforeOffset] - [Y_afterOffset])*([Y_beforeOffset]- [Y_afterOffset])In the 3rd field, calculate: [1st field] + [2nd field]In the 4th field, calculate: sqr([3rd field])This produces the correct results.