How to calculate the 50th percentile

arnaud.philippe

Hello,

Do you know how to calculate the 50th percentile (or any percentile) in Anaplan? 

Thanks!

Arnaud

sobaid

Hi @arnaud.philippe , can you share what you are trying to achieve.

 

arnaud.philippe

We have a population of 100 data points for the same line item, cost per case, and we want to calculate the 50th percentile for this population, in order to filter out the extreme values from it Basically the equivalent of the Excel formula Percentile.Exc

Sai_Bharadwaj_Venati

Hi,

 

This Article should help you

 

https://community.anaplan.com/t5/Anaplan-Platform/Creating-QUARTILE-function-within-Anaplan/td-p/89381

 

Thanks & Regards,

Sai Bharadwaj