Add MEDIAN Function to Anaplan

Options

As we expand our use cases within our org, we are faced with more and more times that we need to calculate a Median within a data set (ex. Revenue, Median Deal Value, Median Salary, etc.).  There is a quite elaborate workaround that is posted on the community, which has been a lifesaver, but it takes up to 13 line items to calculate the median value.  If you need to see that by a different list (think Median Salary by Region vs Median Salary by Job Function) you are stuck recreating different flavors of those 13 line items, potentially in many modules over and over again.  This seems like an incredible amount of overhead for a calculation that is done incredibly simply in excel. 

 

As Anaplan moves more into positioning itself as an advanced analytics tool, the ability to calculate the Median via a function/formula will be critical.  

21
21 votes

New · Last Updated

Comments

  • I totally agree with you, Median should be a standard, built-in function.

     

    About workaround, I've never needed 13 line items, just 3 are usually enough:

    MKierepka_2-1641401983600.png

    Check for 10 items:

    MKierepka_0-1641401962800.png

    Check for 9 items:

    MKierepka_1-1641401969000.png

     

Get Started with Idea Exchange


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