Divide does nothing

Question

I'm attempting to create percentile scores. My query generates the ranks correctly, but the divide does nothing(the ranks are displayed in the columns rather than scores)

"/"(RANK() OVER(ORDER BY "Disk IO"),Count(*)) "Disk IO Score"

I've also tried generating the rank then selecting that and dividing, but it has the same result.

SELECT ..."/"("Disk IO Score",Count(*)) "Score"...
FROM(....RANK() OVER(ORDER BY "Disk IO") "Disk IO Score"...)

Thanks, Buzkie

SELECT "System_Name", "/"(RANK() OVER(ORDER BY "Disk IO"),Count(*)) "Disk IO Score" 
FROM (Select...)
GROUP BY "System_Name", "Disk IO"

Answer 1

Seems you are using aggregate COUNT(*) rather than analytic one.

Try this:

SELECT  RANK() OVER (...) / COUNT(*) OVER (...)

And could you please post the whole query (including GROUP BY clauses)?

Answer 2

I guess it's answered. The count(*) was returning 1 so I was just dividing by 1.