Forum Discussion

clem312's avatar
clem312
Resolver I
4 years ago
Solved

Average staff weighted

Hi,   I have two columns : WEIGHT and STAFF WEIGHT STAFF 89,857142857 10 61,384615385 5 61,384615385 1 76,316666667 6 76,316666667 3 29,111111111 29,111111111 101,791666667 9 76,316666667 7 86,...
Need Help
  • clem312's avatar
    clem312
    4 years ago

    I found the right answer :

     

    DIVIDE
    (
    CALCULATE(SUM(STAFF*WEIGHT))
    ,
    CALCULATE(SUM(WEIGHT))
    )
clem312's avatar
clem312
Resolver I
4 years ago

I found the right answer :

 

DIVIDE
(
CALCULATE(SUM(STAFF*WEIGHT))
,
CALCULATE(SUM(WEIGHT))
)