For creating a loop in alteryx

[ashwin121]

I have a dataset for which i have to create 3 new column interest, principal and POS. The interest column in dependent on POS, the principal column in dependent in interest and POS is dependent on principal.

I tried using using a multirow formula, the subsequent below rows are not populated.

Attaching the workflow and the logic to be used in a Excel file.

Thanks in advance.

[ashwin121]

Attaching the file

[danilang · Accepted solution]

Hi @ashwin121 

You can solve this by calculating all the POS first and then the monthly interest and finally the Principal 

To calculate the current month's POS use this formula

Prev POS          Monhtly Pmt      Interest amt of current Pmt

[Row-1:POS] - ([EMIAmount]- [Row-1:POS]*(([NewIRR]/100)/12))

Using this form of the formula, the monthly POS is only dependent on the previous month POS. 

Next calculate the Monthly interest using [Row-1:POS]*(([NewIRR]/100)/12).  Finally the Principal is calculated using a formula tool with [EMIAmount]-[Interest]

Both the Multi-row formula tools group by account to restart the calculations for each new client

The Results look like this 

Dan

[ashwin121]

This worked. Thanks for the help!.