Hello
Queries offer the possibility to define a "key figure total" as summation or average (among others).
Does someone know how to determine "weighted average" calculated figures.
Example: I have a query with "days taken" by customer by "monthly period". If I want to make a total for this customer I have only "average" which is better than sum but not totally correct. The correct "days taken" by customer should be the weighted average of days taken based on amounts by month.
Customer X
Days taken 01/2005 20 days Amount 100 EUR
Days taken 02/2005 30 days Amount 300 EUR
Average: 25 days
Weighted average: 27.5 days (20100+30300/400)