Filter Products that gets 50% of turnover

[system]

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…

I’m not sure you can do exactly what you want, since you won’t be able filter the data based so that only those that contribute to the top 50% are visible.

---

Steve Krandel (BOB member since 2002-06-25)