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 TierBalance Of MoneyLower LimitUpper LimitInterest Rate120001652%201652204%3022099999996% 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 !!!!!!!! TierBalance of MoneyLow LimitUp LimitBal Carried Down New TierInterest RateRunning Total Daily Balance11650165352%16523516522004%2003022099906% need this to keep looping through the tiers also , It can loop into Tier 3 Bal Money.xlsx

Charging Interest as different Groupings / Bands for Money on Deposit

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

Bal Money.xlsx

Best Practices

Accepted answers

FinnCharlton

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:

Interest Tiers.yxmd

All comments

FinnCharlton

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:

Interest Tiers.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703