Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
A good challenge. I stuck with using the formula tool, however I sense a good solution would have used the Multi-Row formula to with an IF statement to work out reducing balance. I could not quite figure it out, so I stuck with the formula tool