Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

How to do weighted calculation

Highlighted
7 - Meteor

I have table 1 and 2 as below. I want to get output as mentioned below. Can you help? Thanks

Table 1 - Values
CustValue
Cust A50
Cust B

80

 

Table 2 - Monthly Weight
CustMonthWeight
Cust AJan50%
Cust AFeb30%
Cust AMar20%
Cust BJan40%
Cust BFeb15%
Cust BMar45%

 

Output  
CustMonthValue
Cust AJan         25.0
Cust AFeb         15.0
Cust AMar         10.0
Cust BJan         32.0
Cust BFeb         12.0
Cust BMar         36.0
Highlighted
9 - Comet

Hi @anamik72 

 

This might be to basic for what you're data needs, but you can use a Join and Formula tool to get to the weighted averages. 

 

Maskell_Rascal_0-1586978760135.png

Let me know if this works for you. 

 

Thanks!

Phil

 

 

Labels