topic Weighted average in QlikView

Weighted average

Tue, 08 Dec 2009 18:05:23 GMT

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

Weighted average

tabletuner — Tue, 08 Dec 2009 18:28:33 GMT

i guess something like:

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

)

Weighted average

Tue, 08 Dec 2009 20:02:24 GMT

Hi Elad,

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

Weighted average

Tue, 08 Dec 2009 20:49:50 GMT

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.