How to find out percentile for certain values in a column

[acaryasin01]

Hi,

I want to find out percentile for certain values in a column.

I have attached the desired column and calculation, please see the attached screenshot.

And also here is the table

Thanks in advance...

Id	Completed	Hours	Desired Column
19325	Not	6	0,739130435
19325	Completed	17
19547	Not	6	0,333333333
19547	Completed	3
19594	Not	43	0,14
19594	Completed	7
20790	Not	6	0,333333333
20790	Completed	3
20791	Not	6	0,333333333
20791	Completed	3
21222	Not	5	0,444444444
21222	Completed	4

[Qiu]

@acaryasin01 
Maybe we can try use the multi-row formula tool

[messi007]

@acaryasin01,

Please see below : 

Attached the workflow,

Regards,

[Qiu · Accepted solution]

@acaryasin01 
Just have a quick sample flow for you.

[acaryasin01]

Perfect, it works 👍👌

@Qiu Thank you so much Qiu, much appreciate🙏

[acaryasin01]

@messi007 Thank you for your response.