Challenge #425: Weekly Allowance Distribution

[Sumedha992]

Hi team, 

Attaching my working here. Please review and share your comments.

thanks.

[RWvanLeeuwen]

Here's my take

Spoiler

I could have done everything in 1 tool, but I thought this would simplify things by visualising the process

[steven_quehan]

Solved

[ahsanaali]

Spoiler

 

[TobiasFitschen]

Spoiler

 

[fmilliren]

Like many others I didn't see the need to use a multi-row formula tool. I did make it dynamic enough that one could change the allowance amount or the amount to be spent weekly to see different outcomes.

Spoiler

[rvsaders]

Since it was just 4 weeks, I found it quicker to just write formulas for each week. However, I can see where if you were doing this over a longer period it would make sense to use Multi-Row Formula.

[logdog0411]

Been on an iterative macro kick lately... 

Spoiler

 

[plozbin]

My solution. My approach is pretty brute-force. I'm not sure if there is a way to make this more dynamic/scalable in case the number of records or the number of weeks increases/decreases for any reason.

Spoiler

 

[3I_ATLAS]

Solution with 5 formulas with user constants.  Is there a possible solution with using 2 or less tools with a single expression calculating and assigning the values for all 5  distinct fields?

Spoiler

if [Amount]>=[User.allowance]*2 then [User.allowance]
else
[Amount]-([User.allowance])
endif