
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculating Fill rate
Hello, I am very new to QV and have a problem I can't manage to figure out so far.
Here it is: I have a number of records and I need to calculate how many of them are in the 90
I want to know the value of [order to supplier ship] which is a measurement in days when the count of [order_no] has passed 90%
I used to do this in Excel with a pivot table and some formulas and the results looked like this:
Order to supplier ship (days) | Count of order_no | Cumulative Count | % filled | 90% FR |
1 | 151 | 151 | 36.47% | 2.49 |
2 | 201 | 352 | 85.02% | |
3 | 42 | 394 | 95.17% | |
4 | 14 | 408 | 98.55% | |
5 | 5 | 413 | 99.76% | |
6 | 1 | 414 | 100.00% | |
Grand Total | 414 |
So this output here told me that for my 414 orders, it took 2.49 days to achieve the 90% fill rate.
in QV, I am not sure what functions I should be able to use to calculate this, I was playing around with FRACTILE, but so far I can not figure it out.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
RangeSum(Above(SUM(Orders),0,RowNo()))/Sum(TOTAL Orders)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks for the quick response, perhaps I did not structure my question correctly.
I don't want to run the formula against that pivot table output, I want to recreate the 2.49 value using a QV formula that checks all the records, counting the "Orders", and giving the "order to suppliership" value in days.
each cycle, there could be a different number of orders, depending on overall volume...
