Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
20 - Arcturus
20 - Arcturus

@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
20 - Arcturus

@IreneTrieu Another option

binuacs_0-1685542816579.png

 

Deano478
11 - Bolide

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

 

Deano478_0-1685543188527.png

 

Labels