Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Formula - % of total

IreneTrieu
7 - Meteor

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: 
CITYDept #Headcount  
YORKABC6  
PEELDEF5  
TORONTOGHI1  
MARKHAMJKL1  
SCARBOROUGMNO1  
     
Output:    
CITYDept #Headcount% split 
YORKABC60.428571 
PEELDEF50.357143 
TORONTOGHI10.071429 
MARKHAMJKL10.071429 
SCARBOROUGMNO10.071429 
     




4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@IreneTrieu 
Personally I like to use the Transpose and Cross Tab to do this kind of issue.

a.PNG

IreneTrieu
7 - Meteor

Thank you for the quick reply.  Is there a shorter or quicker way of doing this?

binuacs
21 - Polaris

@IreneTrieu Another option

binuacs_0-1685542816579.png

 

Deano478
12 - Quasar

@IreneTrieu  Similar to the guys here another way of doing this:

 

Deano478_0-1685543188527.png

 

Labels
Top Solution Authors