How to calculate the 50th percentile

arnaud.philippe · June 2022

Hello,

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

Thanks!

Arnaud

sobaid · June 2022

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

arnaud.philippe · June 2022

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 · June 2022

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

How to calculate the 50th percentile

Answers

Categories