topic Re: Tabel values rounded to step by 0,5 ex. Value 2.6632 to 2.5 and 8,7601 to 9.0 in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/tabel-values-rounded-to-step-by-0-5-ex-value-2/m-p/41034#M1493 <HTML><HEAD></HEAD><BODY><P>I think you can get to it through the field calculator, Python parser, using an expression like:</P><PRE class="language-python line-numbers"><CODE>round<SPAN class="punctuation token">(</SPAN>!your_field_name!<SPAN class="operator token">*</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN><SPAN class="number token">2.0</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>So, your examples:</P><P>2.66 * 2 = 5.32</P><P>round(5.32,0) = 5</P><P>5 / 2.0 = 2.5</P><P></P><P>8.76 * 2 = 17.52</P><P>round(17.52,0) = 18</P><P>18 / 2.0 = 9.0</P></BODY></HTML> Thu, 02 Feb 2017 21:45:58 GMT DarrenWiens2 2017-02-02T21:45:58Z Tabel values rounded to step by 0,5 ex. Value 2.6632 to 2.5 and 8,7601 to 9.0 https://community.esri.com/t5/geoprocessing-questions/tabel-values-rounded-to-step-by-0-5-ex-value-2/m-p/41033#M1492 <HTML><HEAD></HEAD><BODY><P>How do i tranform tabel values&nbsp;&nbsp;values rounded to steps of 0,5? ex. Value 2.66 to 2.5 and 8,76 to 9.0 in arcgis 10?</P><P>I need them to be rounded in step by 0,5.</P><P></P><P>Thers probably some easy solution, the only thing i found is round to nth. But not quite what I'm locking for..</P><P></P><P>Always greatfull for all the help we get here!</P><P></P><P>/J</P></BODY></HTML> Thu, 02 Feb 2017 21:36:13 GMT https://community.esri.com/t5/geoprocessing-questions/tabel-values-rounded-to-step-by-0-5-ex-value-2/m-p/41033#M1492 JohnnyJohansson 2017-02-02T21:36:13Z Re: Tabel values rounded to step by 0,5 ex. Value 2.6632 to 2.5 and 8,7601 to 9.0 https://community.esri.com/t5/geoprocessing-questions/tabel-values-rounded-to-step-by-0-5-ex-value-2/m-p/41034#M1493 <HTML><HEAD></HEAD><BODY><P>I think you can get to it through the field calculator, Python parser, using an expression like:</P><PRE class="language-python line-numbers"><CODE>round<SPAN class="punctuation token">(</SPAN>!your_field_name!<SPAN class="operator token">*</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">/</SPAN><SPAN class="number token">2.0</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>So, your examples:</P><P>2.66 * 2 = 5.32</P><P>round(5.32,0) = 5</P><P>5 / 2.0 = 2.5</P><P></P><P>8.76 * 2 = 17.52</P><P>round(17.52,0) = 18</P><P>18 / 2.0 = 9.0</P></BODY></HTML> Thu, 02 Feb 2017 21:45:58 GMT https://community.esri.com/t5/geoprocessing-questions/tabel-values-rounded-to-step-by-0-5-ex-value-2/m-p/41034#M1493 DarrenWiens2 2017-02-02T21:45:58Z