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

Line by Line execution of interdependent columns

Sonali_25
5 - Atom

Hi,

 

I have an excel file where I need to create two columns. Each column has formulas that are interdependent on the other column.

The excel file looks like this -

 

Payment No.PIK InterestPIK AccrualEnding Principle
---110000000
324%391111110391111
904%  
904%  
904%  
904%  
904%  
904%  
904%  
904%  

 

"PIK Accrual" Column is calculated as (110000000*0.04*(32/360)) which equals to 110000000 whereas,

"Ending Principle" Column is calculated as (391111+110000000) which equals to 110391111.

 

That is, to calculate "PIK Accrual", we need to have the prior row of "Ending Principle" populated and to calculate "Ending Principle", we need to have the active row of "PIK Accrual" populated.

 

Please Note : Only the starting value of "Ending Principle" (i.e., 110000000) is given in the data set as shown above.

 

I have attached the excel file with the formula for your reference.

 

 

 

3 REPLIES 3
afv2688
16 - Nebula
16 - Nebula

Hello @Sonali_25 ,

 

Hope this helps. The way I solved it was using an iterative macro.

 

Untitled.png

 

Cheers

JoeS
Alteryx
Alteryx

Hi @Sonali_25 

 

I was just beaten to it by @afv2688 however, I went the more straight forward way (not necessarily any better) of two multi-row formulas.

 

LineByLine.jpg

Sonali_25
5 - Atom

Thank you so much @afv2688 and @JoeS  for the quick help. Both the concepts are working absolutely fine.

 

Much Thanks !!

Labels