|
Hi I am trying to do a percentage calculation and I dont know how to get it to work in sql. I am trying to get a success% ie [Total In] 91, [on time] 44, Late 47, [Success] answer would be 48%. can anyone tell me how to do this calculation? If anyone knows how to do this I would be very grateful.
(comments are locked)
|
|
Try this. If the fields are integers you will need to convert [on time] to a decimal, otherwise you will be doing integer divsion that will give 0.48
(comments are locked)
|
|
Thanks :), I had to convert it so it now shows as 0.48
(comments are locked)
|
Your answer
