How do I access the value in a column in a dataste and use it on another dataset

[TimBlaze]

Hi Everyone, 

I am quite new to Alteryx. I have a process in Alteryx designer which produces two different outputs. 

Output A looks like this: 

Total

1200

Output B looks like this

Group	Count	RunTot_Count
A	100	100
B	200	300
C	300	600
D	400	1000

I am trying to divide all the values in the RunTot_Count Column in Output B by the value of the Total Column in Output A. 

Any help will be much appreciated. Thank you very much.

[alexnajm]

Use the Append Fields tool, followed by the Formula tool to complete your calculation!

[usmanbashir]

@TimBlaze - please see attached workflow. Hope this helps! 

[TimBlaze]

Thanks all, Really appreciate it!