Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
Still cant upload images to the community but was able to solve this by pivoting and joining. A couple interesting tools - Multi-field formula and dynamic rename make an appearance!
Small gripe: The question does ask for a percentage but the answer suggests a decimal, watch out for that one!