Percentile formula

Options

It would save a lot of time and space to have percentile formulas in Anaplan. Percentiles are very valuable to eliminate extreme values from data sets and improve the accuracy of our forecasting models.

 

Having a percentile formula would address the need for a median formula at the same time.

 

Further below are a few community links on this subject, that illustrate the need for built-in formulas:

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

https://community.anaplan.com/t5/Anaplan-Platform/Median-Calculation-on-Multiple-Dimensions/m-p/143844#M38431

https://community.anaplan.com/t5/Anaplan-Platform/Calculate-median-value/m-p/35544#M1549

https://community.anaplan.com/t5/Idea-Exchange/Add-MEDIAN-Function-to-Anaplan/idi-p/128322

 

Thanks
Arnaud Philippe

8
8 votes

New · Last Updated

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!