How to rank on a variable that has lots of NA's or 0's

Does anyone have a good way to rank when the majority of stocks have NA / 0 for a variable? For example, I’m looking at Dividends Paid for small caps. Most don’t pay anything so the ranking ends up with the top decile doing well, but then the other deciles just come in as zero.

I’m sure someone has thought of a good way to fix this, any help would be greatly appreciated.

You could try and create a universe using the screen Dividends Paid > 0, name it DivPaid for example… Then when you view the ranks in the Ranker, set your universe to DivPaid…