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

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…