Looking for Help With Multiple Formulas

Question

Hello Community,

I am in desperate help trying to reproduce what I did on the attached Excel Sheet on Alteryx.  This is a process that I need to reproduce and I hope that it can be done via Alteryx.

$ # 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.

Thank you!!

Fausto

Sales Data Sample With Excel Calcs.xlsx

Fescobar · Answer

Hi .@TrevorS

As I mentioned on the post, I dont have a formula, I am asking if what I did with Excel is possible in Alteryx, and if it is so, how can I accomplish it.

The 1st Sheet on the Excel document has my dataset, while the 2nd sheet has the results of the calculation/formulas created in Excel.  The 2nd sheet is what I would like to replicate in Alteryx with the data from Sheet 1.

I hope this clears it up,

Thank you,

Fausto

Sales Data Sample With Excel Calcs.xlsx

TrevorS · Answer

Hello @Fescobar 
Thank you for your contribution to the Community!

To help make it easier for others to assist, it would be helpful to get some additional information on your question. Here's what we recommend you include in your reply:

* What Alteryx Version are you using?
* Do you have a Workflow with sample data you can share?

What is the output you are trying to get?

Posting for Fastest Possible Solution (https://community.alteryx.com/t5/Alteryx-Community-Resources/Posting-for-Fastest-Possible-Solution/ta-p/178481)

Thank you very much!