Challenge #432: Sequential Logic

[Michael_Draper]

Tried an iterative macro with simple logic within, just takes the last record and iterative creates each new record.

Spoiler

Macro:
Workflow:

[Qiu]

I go with the Interative Macro approach.
It is really funny that I just answered a fundamentally same question in the community yesterday.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Weighted-Average-Cost-computat...

Spoiler

[Qiu]

@Michael_Draper 
Much simpler than mine.
Really nice and learned something. 😁

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow Main

Workflow Iterative Macro

[olga_strubbe]

Thank you, @patrick_digan, for a neat challenge!  This was definitely was a brain teaser. 

I approached the solution by building an iterative macro.  Thank you, @ggruccio  and @ed_hayter, for iterative macro ideas!

My workflow:

Macro:

[TurboToad]

Felt a little 'dirty' with this solution but works 😊

Spoiler

Multi-row Formula:
iif([Name]='A' and isnull([Value]),[Row-3:Value]+[Row-2:Value]+[Row-1:Value],
   iif([Name]='B' and isnull([Value]),[Row-4:Value]-[Row-3:Value],
    iif([Name]='C' and isnull([Value]),[Row-5:Value]-[Row-4:Value]-[Row-3:Value]
 ,[Value])
  )
)

[RWvanLeeuwen]

here's my take

Spoiler

I could have simplified the workflow by generating rows starting from Record=4, but this deduplication step was fun to implement though

[aatalai]

Many multi rows tools, but I'm sure there is a macro way to make it more efficient.

[Flo_P]

Forced myself to use an iterative macro approach since I tend to avoid, good learning experience

Spoiler

  

[rkakde]

Spoiler

Spoiler