cancel
Showing results for 
Search instead for 
Did you mean: 

Weighted average for total values in BEx Query

Former Member
0 Kudos

Hi experts,

we want to show the weighted average for total values in a BEx Query:

Example:

DeliveryDelivery QuantityDelivery days to lateDelivery days to late (weighted)
471151260
47122510
47133824
Total1094
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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

This Worked for me as well

cheers!