Hello Everyone,
I hope that you all had a great weekend.
I have been banging my head on my keyboard for a few days now trying to come up with what I had to do in Excel in Alteryx. Unfortunately, I had to resolve to using Excel because it was taking longer that it should have. I wanted to see if this is even a possibility.
This is a quick explanation to what the columns mean.
$ # WE MM/DD/YY = Sales Week Ending Month/Date/Year
$ % Chg YA # WE MM/DD/YY = Sales Percent Change Week Ending Month/Date/Year
9L EQ # w/e MM/DD/YY = 9 Liter Equivalent Sales Week Ending Month/Date/Year
9L EQ % Chg YA # w/e M/DD/YY = 9 Liter Equivalent Sales Percent Change Week Ending Month/Date/Year
Avg Unit Price # w/e M/DD/YY = Average Unit Price Week Ending Month/Date/Year
Avg Unit Price % Chg YA # WE w/e M/DD/YY = Average Unit Price Percent Change Week Ending Month/Date/Year
The attached file has the work I did in Excel and I would like to be able to replicate this in Alteryx because I already have a formula that combines two different sheets. I am adding the different weeks and converting numbers percentages to come up the values on the second sheet.
This is a process that I will need to tackle pretty often in the future and it would be great to do the calculations in the same workflow I am using to join the two datasets I am working with.
Thank you!!
Fausto
