Populating values row by row

[josephcmk]

Hi Everyone, I'm still pretty new to Alteryx Designer Desktop. Just wanted to know if there is a way to populate values for different columns row by row as each column's formula is interdependent. I have attached the screenshot and sample file. For context, I have initialized the first row's value and set the rows onwards to zero using the formula tool. I have tried to use the multi row formula tool to execute this but only the next row's data is being filled. Thank you for your help! 

Fields to Create/Update:
Interest: [Balance] * [IRR]
Principal: [Monthly Rental] - [Interest]
Balance: [Previous Row Balance] - [Principal]

[OTrieger]

@josephcmk 

Unlike excel, Alteryx data is defined by columns so I do not see the issue that you should have. You can set a stand alone formula for each columns and so each row will get updated accordingly.

Not sure what you are trying to achieve and why you would like to use the multi row formula. 

[kamanivk]

Use Formula tool to add new columns you need and specify the formula required for each.

I see you wanted to create 3 new columns.

In the Formal tool, create 3 new columns each with its own formula.

The output of the formula tool will have the 3 additional columns.

[CoG]

Considering, the fields and formulae you've provided, the Multi-Row Formula Tool is precisely the tool for the job, since you are referencing prior rows. Unfortunately, there appears to be a circular reference that will prevent you from solving this problem as written. Can you share the details about how you would calculate the values for Row 2 based on your Sample Data?

Circular Reference:

1. [Balance] requires [Principal], which requires [Interest].

2. [Interest] requires [Balance]