lookup day by comparing running counts
Hello,
I need some help building a formula for following,
Following data shows no. of records finalised in days.
example - 905 records finalised in 1 days.
3rd column is running sum.
I need to come up with column 4 and 5.
| Finalised in Days | Records Count | Running Records Count | % | % on running count |
| 0 | 1037 | 1037 | ||
| 1 | 905 | 1942 | ||
| 2 | 909 | 2851 | 25% | 2679.75 |
| 3 | 790 | 3641 | ||
| 4 | 817 | 4458 | ||
| 5 | 909 | 5367 | 50% | 5359.5 |
| 6 | 1418 | 6785 | ||
| 7 | 1380 | 8165 | 75% | 8039.25 |
| 8 | 1027 | 9192 | ||
| 9 | 794 | 9986 | ||
| 10 | 733 | 10719 |
Requirements -
WINDOW_SUM(SUM([CFY - Count])*0.25) in between "Running Records Count" then i need "Finalised days"
so In need 25% - 2; 50% - 5; 75% - 7
work book attached
Sep 6, 2017 4:19 AM
