Percentile Rank


How can I calculate the percentile rank of a value? (
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


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

Yeah, it’s the same function as in google sheets:

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


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

Thank you. I appreciate your help :blush: