This question already has an answer here:
I have fields in my datasets such as HR60, HR70, HR80, HR90
When I tried to use field calculator using the following [HR70]/[HR60], all I got was 1, 2, 3, 4 as my values.
Last time I checked 1.14/2.24 is not 1 and 2.92/.69 is not 4.
In a map I did using field calculator using [ ]/[ ]*100 to get percentages and it let me do that so why this time am I getting whole #'s and not the appropriate decimals?