Forum Discussion
Anonymous
8 years agoNot applicable
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 Days |
| Brazil | 139 | 22,0 |
| USA | 12 | 19,0 |
| Total | 151 | 21,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!
More or less the first google result, but anyway...
4 Replies
- AnonymousNot 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)
- AnonymousNot applicable
Can someone please help me?
- jthomsonSolution Sage
More or less the first google result, but anyway...
- AnonymousNot applicable
Thanks anyway!