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... IdCompletedHoursDesired Column19325Not60,73913043519325Completed17 19547Not60,33333333319547Completed3 19594Not430,1419594Completed7 20790Not60,33333333320790Completed3 20791Not60,33333333320791Completed3 21222Not50,44444444421222Completed4 image.png

How to find out percentile for certain values in a column

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...

Workflow

@acaryasin01
Just have a quick sample flow for you.

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

Please see below :

Attached the workflow,

Regards,

@acaryasin01
Just have a quick sample flow for you.

Perfect, it works 👍👌

@Qiu Thank you so much Qiu, much appreciate🙏

@messi007 Thank you for your response.