Percentile Rank

Support
1

Hello,

How can I calculate the percentile rank of a value? (https://en.wikipedia.org/wiki/Percentile_rank)
Lets say I have a table:

Product Count Price
A         3     10
B         2     5
C         5     3

I would like to add a column “Percentile Rank Price”

Product   Count   Price    Percentile Rank Price
A           3     10         100
B           2      5         70
C           5      3         50
2

Hi,

Just to confirm, are you referring to this function in Excel?

3

Yeah, it’s the same function as in google sheets:
https://support.google.com/docs/answer/3094095?hl=en

Is there any way to use it in here or to calculate this value is any way here?

4

Hi,

I’ve reported the feature request to our developers and will keep you posted once the feature released.

5

Thank you. I appreciate your help :blush: