Forum Discussion

clem312's avatar
clem312
Icon for Resolver I rankResolver 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,320000000	65
59,700000000	1
27,242718447	1
59,700000000	3
27,242718447	1

I want to make the average of staff weighted.
I can't find the right function.

Need Help
  • clem312's avatar
    clem312
    4 years ago

    I found the right answer :

     

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

3 Replies

  • clem312's avatar
    clem312
    Icon for Resolver I rankResolver I
    4 years ago

    I found the right answer :

     

    DIVIDE
    (
    CALCULATE(SUM(STAFF*WEIGHT))
    ,
    CALCULATE(SUM(WEIGHT))
    )
  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi clem312 ,

    Here is the function you can use: AVERAGE .

    If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

  • clem312's avatar
    clem312
    Icon for Resolver I rankResolver I
    4 years ago

    I know AVERAGE. The question is more about the weight.

    They have to be considered.