Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution attached.
Used a regex expression to tokenize the field into many columns, then transposed the data and parsed with regex expression, and lastly converted the string to double and summarized.
Alteryx UI has come a long way.
Once I realized that there were multiple $ values in one row this became pretty straight forward.
My solution :)
Complete! Really fun to see it with the old tool designs
Art change is definitely an upgrade!