on 03-06-2019 7:08 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.