Percentile formula

arnaud.philippe

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