95th Percentile

[system]

Hi,

How to calculate the percentile in Deski.
The syntax in the help shows below:

Number Percentile(number; percentile value)

Example
Object=1,2,3,4; Percentile(Object,0.3) returns 1.9

i have column count(ID) which is grouped on a specific category like below:

Category count(ID) 95th percentile

A 10
B 20
C 30

Likewise, i need to create a column with 95th Percentile.

Please suggets me how can i do this.

---

pradeep_forum (BOB member since 2006-08-25)

[system]

Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

120×120 10.4 KB

I have a user who is trying to calculate the percentile of a measure object (Score). Having some problems getting this to work as expected. I have not really found anything that will help, but it seems to be a context problem since we are getting the #computation error in the field. User has defined a dimension variable that converts a string “score” to a number using ToNumber(TextScore) They have then defined another variable to calculate the perentile using =Percentile(<Score> , 0.1) Fir…

---

Nick Daniels (BOB member since 2002-08-15)