Charging Interest as different Groupings / Bands for Money on Deposit

[Tommy_Alterax]

HI Guys,

I need to workout how much money earned at different interest rates - The interest rate received depends what range it sits in ;

So below I would need Alteryx to see the 200 and that 165 of this is charged at 2% (change balance of money column to 165 - currently at 200)

Do the Math and Pass 35 onto Tier 2 - Balance of Month in Tier 2 = 35 and loop in like that 

Tier	Balance Of Money	Lower Limit	Upper Limit	Interest Rate
1	200	0	165	2%
2	0	165	220	4%
3	0	220	9999999	6%

Desired outcome after Alteryx would look something like this (below) - The Balance of Money Column is the critical column I need to show how much money sits in each Tier - HEEELLLLLPPPPPP !!!!!!!!

Tier	Balance of Money	Low Limit	Up Limit	Bal Carried Down New Tier	Interest Rate	Running Total Daily Balance
1	165	0	165	35	2%	165
2	35	165	220	0	4%	200
3	0	220	999	0	6%

 need this to keep looping through the tiers also , It can loop into Tier 3 

[FinnCharlton · Accepted solution]

Hi @Tommy_Alterax , here's a way to do it with multi-row formula tools. Give it a test and make sure it performs like you want:

[Tommy_Alterax]

This is amazing - U are a very very intelligent person - Thank you so much !!!!!!! 

[Tommy_Alterax]

Hey I found a problem with your workflow - If I chance Balance of Money to 240 (in the text input)

Then I get a running total of 260 ? not sure why - I was just testing out some scenrios

Tier	Balance Of Money	Lower Limit	Upper Limit	Bal Carried Down New Tier	Interest Rate	Running Total Daily Balance
1	165	0	165	75	2%	165
2	75	165	220	20	4%	240
3	20	220	999999	0	6%	260

[Tommy_Alterax]

I think this fixes it in the formulae tool - highlighted in yellow