Weighted average

[#1]

Hello,

I try to calculate weighted average

The goal is to calculate weighted average sales per employee.

The formula is:

((Sum sales month x * sum employee in month x) + (Sum sales in month y * sum employee in month y)/sum employee (in month x)+ sum employee (in month y))/ sum employee (in month x) + sum employee (in month y))/count month)

For example:

In month X the sales is 100 $ and the employee number is 10

In month Y the sales is 200 $ and the employee number is 5

The formula will be:

(100*10)+ (200*5)/(10+5)/

10+5/2

How I write this formula in QV?

Thank you

Elad

[tabletuner]

i guess something like:

=

sum(Sales*[Employee #])/sum([Employee #]

)

[#3]

Hi Elad,

I have attached an example application and hope this gets you going.

[#4]

Thank you for your answers,

I'm looking for the way to see in my Y axis our company division and in axis X the employee amount.