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.