Percentile formula

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

Comments

Quick Links

New ideas

Anaplan Color Pallet
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: The Anaplan Color pallet should be consistent across all forms. Text Pallet is different Action Icon Default Colors, and different…
Workflow: Continue Workflow after Decision Task Rejection
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Currently a workflow ends if a decision task is rejected and it is not possible to add workflow steps after the rejection. I want to…
Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.