Fractile Reverse

[amars]

Hi all,

By above name to the thread, what I mean is, by using Fractile Function we can find out 50th Percentile for a given list of values.

I wish to find out the Percentile value for a score, within a given list of Scores.

Is there any function to do that?

Thanks in advance.

Amar

[Gysbert_Wassenaar]

Something like this perhaps: count({<Score={'<=$(vScoreValue)'}>} Score)/count(total Score)

Use a variable vScoreValue to store the score value of which you want the fractile. Then count all scores that are lower or equal to that value and divide that by the total count of scores.

[amars]

If I have to calculate manually, it is becoming quite complex, the formula is like

i.e.

= ( Max( Total Rank) - UpperboundValue of (Individual Score)  ) / Max( Total Rank)

Fore me score is again a calculated value , thus it is becoming quite complex

=((Max(Total Aggr(Rank(Total (ScoreFormulae),3), Dimensions)) - Num(Rank(Total ScoreFormulae,3)))

   /Max(Total Aggr(Rank(Total (ScoreFormulae),3), Dimensions))

The other problem is I wish to calculate it at script level otherwise. Since the value is fixed.

Can you suggest something.

Thanks a lot.