Challenge #14: Warehouse Distribution

[Sajeel_Kershi]

found it easier to go the non macro route

[joona_rauhamaki]

My solution with both the macro and non-macro routes

[joona_rauhamaki]

*deleted*

[Mausam]

My solution with an iterative macro. With this exercise, I have to say that although macros are quite useful in Alteryx, and look intuitive, sometimes it is tricky to make a macro work within Alteryx's framework. 

Anyway my solution is attached.

Macro:

Spoiler

Workflow:

Spoiler

[Owlpet]

Haven't had a chance to learn macro yet. Here's my workflow

[DawnDuong]

Tried a non-macro solution.

Spoiler

[DawnDuong]

Tried a solution that involves a standard Macro and an iterative macro. The non-macro solution seems more elegant though.

[TonyA]

This is a first. My solution is identical to Gene's first solution.

[arjanloogman]

My solution...

Spoiler

Didn't use the running total, I went with the perspective of 'items left' using the multi-row formula...

Kind regards,

Arjan Loogman

[BenBo]

I'm not certain my logic is correct. This felt tougher than others and I haven't tried using a macro. Boo on me!