The formula for finding Percentile rank as per wikipedia is
One of the edge cases in my application is when all the values are zero. In this case the number of scores less than the score of interest is zero, the frequency is equal to the number of total values which is N.
This formula gives me a rank percentile of 50% when all the scores are equal and zero. It seems counter intuitive to suggest that the rank percentile is 50% even though there is not a single score less or more than the score of interest. Is this the correct value?