I am trying to get sql to read my percentage calculation but I cant figure it out. The calcuation is(A.[POLICY TOTAL]  [A.LATE])/A.[POLICY TOTAL] * 100 This will give me the percentage I need butat the moment I am calculating the below which gives me the opposite percentage. so I have one that gives me 20% but I need the other to show me the 80% Can anyone advise if there is such a calculation? Many thanks in advance if so. a.[Late] / a.[POLICY TOTAL])) + '%' [Failedd]
(comments are locked)

You already have shown it how to do it. All you have to do is put the parentheses correctly
(comments are locked)

Thank you for the help Robbin but its not bringing back the percentages I need ie policysin has 12 and Failed has 4 so it would give 33.3% with my calculation where as I am trying to bring back the percentage of 66.66 and so on. Sorry for not being clear.
My solution seems to be doing exactly that
Apr 27, 2012 at 10:57 AM
robbin
(comments are locked)
