Creating New Values from previous rows

Hi everyone,

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

Workflow

Preparation

Expression

Accepted answers

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

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

Something like this?

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

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