Interest Compounding

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.

Workflow

Accepted answers

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

All comments

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/86603

Let me know how you get on.

Luke

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.

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

Amazing! thanks so much!

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

Test 1 - 2.xlsx

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15879

MarqueeCrew 13708

apathetichell 13703