Skip to Content
0
Former Member
Oct 30, 2012 at 11:46 AM

How to calculate percentile in HANA?

395 Views

Hi,

I'm struggling to find a function in SAP HANA that can be used to create a percentile. I'm looking for something similar to the percentile_desc function in oracle that can create a percentile based on a certain subsets of the data.

What I'm exactly looking for:

Example, I have a table with 2 fields country & population of each state within that country

Need to find out the 99th percentile of population (within each country) and impute any value > than that to the 99th percentile.

Any help will be appreciated!

Thanks,


Vignesh