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

Accepted answers

All comments

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

Quick Links

Can you help?

Unanswered questions

ADO data types - need definitions/explanations
what are these? when do you use them? why one over another? thanks Data types string long float bool date datetime datetimetz
API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-