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  HC Working...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

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

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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)