How to calculate the 50th percentile

Options
arnaud.philippe
arnaud.philippe Member, ALL USERS, Community Pioneer Posts: 2 Master Anaplanner of the Year

Hello,

Do you know how to calculate the 50th percentile (or any percentile) in Anaplan? 

Thanks!

Arnaud

Comments

  • arnaud.philippe
    arnaud.philippe Member, ALL USERS, Community Pioneer Posts: 2 Master Anaplanner of the Year

    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