https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038174#M60465 <P>Please post the entire code block.</P><P><A href="https://community.esri.com/t5/python-blog/code-formatting-the-community-version/ba-p/1007633" target="_blank">Code formatting ... the Community Version - Esri Community</A></P> Thu, 18 Mar 2021 17:40:43 GMT BlakeTerhune 2021-03-18T17:40:43Z https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038170#M60463 <P>Hello,</P><P>&nbsp;</P><P>I am trying to calculate a field using another field. The code expression is valid and it executes the code but it does not provide the values i'm looking for. Instead, it shows 0's. But I want it to show values of .2 and .33, respectively for the Assigned Percent Loss field that I am trying to calculate.. Any help is greatly appreciated.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KyleSmiley_nrcs_0-1616088760838.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/8802i21BFCC8DACC534E8/image-size/medium?v=v2&amp;px=400" role="button" title="KyleSmiley_nrcs_0-1616088760838.png" alt="KyleSmiley_nrcs_0-1616088760838.png" /></span></P><P>&nbsp;</P> Thu, 18 Mar 2021 17:33:49 GMT https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038170#M60463 KyleSmiley_nrcs 2021-03-18T17:33:49Z https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038171#M60464 <P>What is the field's data type?&nbsp; It is probably rounding and it should be set to float and the format set to show the correct number format.</P> Thu, 18 Mar 2021 18:00:51 GMT https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038171#M60464 Anonymous User 2021-03-18T18:00:51Z https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038174#M60465 <P>Please post the entire code block.</P><P><A href="https://community.esri.com/t5/python-blog/code-formatting-the-community-version/ba-p/1007633" target="_blank">Code formatting ... the Community Version - Esri Community</A></P> Thu, 18 Mar 2021 17:40:43 GMT https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038174#M60465 BlakeTerhune 2021-03-18T17:40:43Z https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038270#M60467 <P>Looks like "Assign_Per_Loss" is LONG or SHORT datatype. It should be FLOAT or DOUBLE.</P> Thu, 18 Mar 2021 20:03:37 GMT https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038270#M60467 JayantaPoddar 2021-03-18T20:03:37Z https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038296#M60468 <P>Code worked and provided the correct output after changing it from long to float. Thanks everybody!</P> Thu, 18 Mar 2021 20:47:17 GMT https://community.esri.com/t5/python-questions/need-help-with-python-expression-to-calculate/m-p/1038296#M60468 KyleSmiley_nrcs 2021-03-18T20:47:17Z