Good morning,
Can someone please help me with the formula for the below (see input table below). I need to calculate the % split by total headcount (ie. 6 headcount / 14 sum of total headcount = 0.425871)
Thanks in advance
Irene
| | | | | |
| | |
| Input: | |
| CITY | Dept # | Headcount | | |
| YORK | ABC | 6 | | |
| PEEL | DEF | 5 | | |
| TORONTO | GHI | 1 | | |
| MARKHAM | JKL | 1 | | |
| SCARBOROUG | MNO | 1 | | |
| | | | | |
| Output: | | | | |
| CITY | Dept # | Headcount | % split | |
| YORK | ABC | 6 | 0.428571 | |
| PEEL | DEF | 5 | 0.357143 | |
| TORONTO | GHI | 1 | 0.071429 | |
| MARKHAM | JKL | 1 | 0.071429 | |
| SCARBOROUG | MNO | 1 | 0.071429 | |
| | | | | |
