cancel
Showing results for 
Search instead for 
Did you mean: 

Percentile calculation in SAC

sanpe
Explorer
0 Kudos
869

Dear experts,

is there a way to calculate percentile in SAC (either in a model or a story)? Analytic application is in this case not an option.

Thanks.

P.

View Entire Topic
avsalynin
Active Contributor
0 Kudos

sanpe

oh, I'm sorry for not paying attention.

This formula is right - Percentile = (Number of Values Below “x” / Total Number of Values) × 100 ?.

Do I understand correctly that there are problems with the calculation of one of the measure above?

sanpe
Explorer

Thanks a lot, you made me realize that I was focusing on other aspect of the problem, actually this logic works!

Cheers!

P.

RuchikaP
Employee
Employee
0 Kudos
HI Can you pls let me know how should i calculate 90th percentile value based on given total set of values?