Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating New Values from previous rows

Mwatts23
8 - Asteroid

Hi everyone,

 

Mwatts23_1-1653606790872.png

 

 

From the above screenshot, how can you insert a new profit for 2023, 2024 and 2025 based on 2022 for each Region?

 

Below is the sample calculation in excel on how I arrived on the result per year for AMER Region.

 

2023 profit:  (1,197 * 1.25) + 1197 = 2,693

2024 profit:  (2,693 * .87) + 2693 = 5,036

2025 profit:  (5,036 * .56) + 5036 = 7,856

 

Thank you for taking time on my query.

 

Best regards,

Michael

7 REPLIES 7
DataNath
17 - Castor

Hey @Mwatts23 are you able to attach the sample data so we don't have to build this out ourselves? Cheers!

IraWatt
17 - Castor
17 - Castor

Hey @Mwatts23,

I agree with @DataNath its a lot easier to answer questions when you have access to the data. For this issue Multi row formula is the answer: Multi-Row Formula Tool | Alteryx Help

IraWatt_0-1653607989009.png

The tool groups by region then applies the logic if the row above in profit is not NULL then do your formula else keep the value of profit. 

Any questions or issues please ask :)
HTH!
Ira

PhilipMannering
16 - Nebula
16 - Nebula

Hi @Mwatts23 

 

Something like this?

PhilipMannering_0-1653608503202.png

 

Mwatts23
8 - Asteroid

Noted @DataNath. Thank you.

Mwatts23
8 - Asteroid

Thank you @IraWatt! and for the quick response. This is the resolution I need.

 

 

Mwatts23
8 - Asteroid

Thank you @PhilipMannering! for taking time on my query. Have a great day ahead!

IraWatt
17 - Castor
17 - Castor

No worries at all @Mwatts23 ! glad you got it sorted :)

Labels