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 |
Solved! Go to Solution.
@acaryasin01
Maybe we can try use the multi-row formula tool
@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.