Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

weighted average

Hello guys, 

 

My question is preety straight forward, but I can't get this done. 

 

I want to calculate an weighted average on a table with number of days as below:

 

 Country HCWorking Days
Brazil13922,0
USA1219,0
Total15121,76

 

So basically I would need to average the number of days worked in a month for USA and Brazil having the Headcount as a paramenter, the results should be as the one in the table. 

 

Thanks!

  • jthomson's avatar
    jthomson
    8 years ago

    More or less the first google result, but anyway...

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    To make it easier to understand, the mathematical formula would be ((Working days Brazil * HC Brazil)+(Working days USA * HC USA)) / (HC Brazil + HC USA)

  • Anonymous's avatar
    Anonymous
    Not applicable

    Can someone please help me?

    • jthomson's avatar
      jthomson
      Solution Sage

      More or less the first google result, but anyway...

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Thanks anyway!