PERCENTILE_CONT and PERCENT_RANK
623801Apr 4 2008 — edited Apr 7 2008Hello:
We are using Oracle 9i. We use PERCENTILE_CONT to find a value at a certain percentile. But when we use PERCENT_RANK with that value and try to get the percentile back, it is different. In other words, these two functions don't seem to be reciprocals.
Are we expecting too much? If so, is there a way in which this process can be totally reversible? (That is what we need)