Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
My solution.
Spoiler
Workflow
Formula Tool (1)
Quotient = FLOOR([Amount] / [Allowance])
Remainder = Mod([Amount], [Allowance])
Formula Tool (2)
Week = "Week_" + ToString([RowCount])
Allowance =
IF [RowCount] <= [Quotient]
THEN [Allowance]
ELSEIF [RowCount] = [Quotient] + 1
THEN [Remainder]
ELSE 0
ENDIF
Formula Tool (3)
CARRY_FORWARD = [Amount] - [Sum_Allowance]
Formula Tool (1)
Quotient = FLOOR([Amount] / [Allowance])
Remainder = Mod([Amount], [Allowance])
Formula Tool (2)
Week = "Week_" + ToString([RowCount])
Allowance =
IF [RowCount] <= [Quotient]
THEN [Allowance]
ELSEIF [RowCount] = [Quotient] + 1
THEN [Remainder]
ELSE 0
ENDIF
Formula Tool (3)
CARRY_FORWARD = [Amount] - [Sum_Allowance]
