Forum Discussion

harirao's avatar
harirao
Post Prodigy
6 years ago

Percentile Calculation

Hi All, Required assistance, I have to work on Percentile Calculation Normally Percentile works smaller value to larger Value I have to create/calculate 75th Percentile by using a column where Per...
Interesting Links
Need Help
Tips and Tricks
harirao's avatar
harirao
Post Prodigy
6 years ago

Hi Anonymous,

 

Thanks for your response. 
Instead of creating Negative can we create a calculated colum, Larger Value to Smaller value for "Actualy Visibility weeks",  then use percentile calculation?

Regards

Hari

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi harirao ,

Please try to update the formula as below:

Percentile = PERCENTILE.INC(Sheet1[Actually visibility Weeks],0.1)

 

Best Regards

Rena