Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

Alteryx Designer Desktop Discussions

Looking for Help With Multiple Formulas

8 - Asteroid

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

2 REPLIES 2
Alteryx Alumni (Retired)

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/t...)

Thank you very much!

Community Moderator
8 - Asteroid

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

Labels