SOLVED
Formula - % of total
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
IreneTrieu
7 - Meteor
‎05-31-2023
06:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 | |
Solved! Go to Solution.
Labels:
- Labels:
- Output
4 REPLIES 4
21 - Polaris
‎05-31-2023
06:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@IreneTrieu
Personally I like to use the Transpose and Cross Tab to do this kind of issue.
‎05-31-2023
07:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the quick reply. Is there a shorter or quicker way of doing this?
binuacs
21 - Polaris
‎05-31-2023
07:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Deano478
12 - Quasar
‎05-31-2023
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)