Hi Teradata folks,
I am trying to find out how I can do percentile in Teradata similar to what Excel would produce. Is there a function for that? I tried percent_rank but I don't think it's giving me what I wanted.
For example,
data set {1,2,3,4,5,6,7,8,9,10}
in Excel when I do percentile(a1:a10,.8), I got 8.2
Do you all know a quick way to get the same answer in Teradata?
Appreciate in advance for all your help!!!
Shirley
I am trying to find out how I can do percentile in Teradata similar to what Excel would produce. Is there a function for that? I tried percent_rank but I don't think it's giving me what I wanted.
For example,
data set {1,2,3,4,5,6,7,8,9,10}
in Excel when I do percentile(a1:a10,.8), I got 8.2
Do you all know a quick way to get the same answer in Teradata?
Appreciate in advance for all your help!!!
Shirley