interest rate increase

[J-H]

I am trying to multiply an initial value by an interest rate for a number of years. i.e Year 1 = x, Year 2 = x*1.1, year 3 = Year 2 *1.1 and so on. What is the best way to do this? thank you

[DiegoParker]

HI J-H

You could use the multi row formula to achieve this. https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p...

Have a read and let me know what you think. I think it would be very useful for you.

Best,

Diego

[J-H]

Thanks Diego, I have tried to use the multi row formula but I can only make one extra column with the (x*1.1) results - how can i make this repeat for multiple rows? 

[danilang]

Hi @J-H 

Can you post a sample input data file and what you would like the output to look like

Dan

[DiegoParker · Accepted solution]

Hi J-H,

I created a workflow supposing that your data starts on something like this:

Whilst this may not be necessarily the case, maybe the concept will be useful for you.

I created the following workflow:

I configured the generate rows like this, in yellow would be the "Number of years":

Then I got rid of some stuff with the select tool and configured my first multi-row like this:

This will make the years increase by one.

The last multi-row I configured it like this:

and this gave me the following result:

I'm attaching the workflow for your reference.

Hope this helps If does, can I ask you to mark it as correct? this will help other users to find correct answers and will allow us to close the thread. Many thanks!

Best,
Diego

[afv2688 · Accepted solution]

Hello @J-H,

Here's an example on how to do it with multiple variables.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Regards

[J-H]

Thank you!

[J-H]

Thanks Diego!