Hello @graicifyd
You must walk the array of numbers and increase a counter for every value below the number “X”, in your example X=28. And finally, evaluate operation:
(number of values below “X” / number of values)*100
In your example:
(number of values below “28” / number of values) * 100 =
(1/10)*100 =
10
If you need that us to implement a PERCENTIL operation you can call from your equations, you can contact us via the plugin website:
https://cff.dwbooster.com/customization
Best regards.
Hello @graicifyd
If you are referring to the percentilerank, the formula would be:
PR% = (L + ( 0.5 * S ) / N) * 100
Where L is the number of values below “X”, S is the number of values equal to “X”, and N the number of all values.
Continuing with your example:
PR% = ((1 + (0.5)*7)/10)*100
= ((1 + 3.5)/10)*100
PR% = ((1 + (0.5)*7)/10)*100
= ((1 + 3.5)/10)*100
= (4.5/10)*100
= 45
Best regards
Hi,
Thank you so much for the explanation.
This should work.
