I Am trying to do a basic math problem to tell me the percent of column. My sum and count functions seems to work but when I divide them together I dont get an answer. I know its going to be something dumb but this is driving me crazy. Here is a screen shot of what I am trying to do.
You need to cast one of the numbers to double. Both of the numbers are integer, thus the result will also be integer and automatically truncated.