Skip to Content
0
Mar 06, 2019 at 07:08 PM

Percentile over aggregated rows

545 Views Last edit Mar 06, 2019 at 01:55 PM 2 rev

Hello,

I want to have the 95%% lead time in days as a variable. However, when a certain number occurs more than once, the calculation only takes that number once in the calculation. Example:

Leadtime Count
1.................1

2.................1

3.................4

4.................3

Now I want the 95 percentile over [1, 2, 3, 3, 3, 3, 4, 4, 4]. Which would give the result 4. When I use the formula =Percentile([Lead time];0.95), it will give the result 3.85, which is the 95 percentile of [1, 2, 3, 4].

How can I get the 95 percentile taking the count into account?