How to calculate Percentile based on Excel Percentile Rank function

[BootCam]

Hi,

Can Anyone help me with percentile calculation based on the attach file? I just dont know how to use the PercentileRank.EXC function in qlikview to reach the desired percentage numbers in Qlikview.

The calculations are made in Excel but need a bit help to translate that into Qlikview.

Thanks,

[BootCam]

Hi Vinieme12,

Thank you so much for your solution.

Best,

BC