Rank Function Skipping Rank Numbers

lb1234

I'm creating a simple leaderboard which ranks my closers by the number of sales for the selected period and then by total system cost. For some reason, the function I'm using is causing the leaderboard to skip ranks and I'm having trouble figuring out why. Any thoughts?

MichelleH

@lb1234 Try using DENSE_RANK() instead of RANK() to make sure numbers don't get skipped