This question already has an answer here:
NOTE: This problem is similar to one that was answered here: Why does Field Calculator return 0 values when decimals are expected?
I'm relatively new to python, and am trying to run a simple field calculation using US Census data![Screenshot of DOUBLE fields]
I'm trying to do a simple calculation where I sum (Cnt1+Cnt2+Cnt3)/ (Pop1+Pop2+Pop3).
I tried posting screenshots but apparently I don't have any street cred here :(
I have tried creating various types of new fields: double, long, float, and played around with the scale/precision/properties, but everytime it returns "0" values. I know the values will be very small, i.e .04 but it doesn't seem to be a decimal display problem as I tried running it with Pop1/.4 and it correctly returned a decimal. Any suggestions would be much appreciated, sorry about the lack of screenshots!