Skip to Content
0
Former Member
Jul 13, 2005 at 03:47 PM

Weighted average

125 Views

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)