Percentile over aggregated rows

[Former Member]

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?

[Tom_N8]

Hi Aletta,

The way WebI calculates the Percentile with aggregated values is correct. Therefore, you will have to create a dummy variable (type dimension) to force the desired calculation context:

[Dummy] = =RowIndex()+1

Then simply insert the following formula into the table footer: =Percentile(([Lead Time] ForEach([Dummy]));0.95)

Kind regards,

Tom