on 09-29-2014 9:23 PM
Hi experts,
we want to show the weighted average for total values in a BEx Query:
Example:
Delivery | Delivery Quantity | Delivery days to late | Delivery days to late (weighted) |
---|---|---|---|
4711 | 5 | 12 | 60 |
4712 | 2 | 5 | 10 |
4713 | 3 | 8 | 24 |
Total | 10 | 94 | |
Weighted average (94 days / 10 pc.) | 9,4 |
How should we use the exception aggregation to calculate the weighted average correctly?
Many thanks in advance!
Best regards,
Michael
Hi all,
we have fixed the issue with the following key figures:
1. calculated key figure CKF_01 "Delivery days to late (weighted)" with exception aggregation summation and characteristic "Delivery item"
2. calculated key figure CKF_02 "Delivery days to late (weighted)" with 1:1 the calculated key figure CKF_01 and exception aggregation summation and characteristic "Delivery number"
3. calculated key figure CKF_03 "days to late weighted average to late" and the calculation CKF_02 / Delivery Quantity
As the result, for example we can calculate the expected value 9,4.
Thanks and regards,
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.