Interest Compounding

[jtchua02]

new to this forum - im trying to solve a calculation which is simple to achieve in excel but I can't duplicate it in Alteryx.  

I attached the excel workings, column C and column D are the output.  

Any help will be appreciated - I tried looking at a solution, but I can't seem to find out that fits.

[LukeM]

Hi @jtchua02 

The multi-row formula will allow you to refer to rows above/below in the fields you want, so you can replicate the logic in your excel.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p...

Let me know how you get on.

Luke

[jtchua02]

Hi - thanks for the suggestion. I tried this and I can get it to refer to a column I haven't created yet.  Since the Column C and D interact with each other.  If I created column C, the formula I need is link to column D which I haven't created yet, and vice versa.

[hlmess]

You can try something like this formula:

This'll incorporate the value that's being held in column D as a component of the calc for column C. You replace the reference to last row's Interest with the formula last row's interest used.

Once you've got the Cumulative Cash Flow this way, you'll just need a second Multi-Row Formula to get the Interest column.

[benakesh · Accepted solution]

Hi @jtchua02 ,

Calculate col  C  first and then col D .   

excel:  col c  =C2+D3+A3        (  instead of  d3  use  formula for d3 )  

multi row 1:

[Row-1:cf] +
[Cash flow] +
[Row-1:cf] * [Days] * 0.000210874398376859

excel: col d  =C2*B3*0.000210874398376859

multi row2:

[Row-1:cf] * [Days] * 0.000210874398376859

[jtchua02]

Amazing! thanks so much!

[Kjaer]

@benakesh 

Hi Your solution is also what I was looking for. But will it be possible also to make the calculation of days?

See my example

Best regards 

Kjaer