I am currently trying to work on ArcMap for practice, and I keep running into a problem when trying to divide between two fields. Just to give people an idea with what I am working on, I created two short integer fields, and I created a third field to divide between the two and identify a decimal answer. I have tried using this field as a float and as a double, and I have had the Precision set to "0" and "3" with the Scale set to "0" and "2". However, every time I try to divide between the two short integer fields, I routinely receive the answer "There was a failure during processing." I don't understand why I keep getting this error, the only reason I can think of is since I'm dividing between two short integer fields to identify a decimal.
If someone could help me with this problem, it would be well appreciated.