Tried an iterative macro with simple logic within, just takes the last record and iterative creates each new record.
Spoiler
Macro:
Workflow:
I go with the Interative Macro approach.
It is really funny that I just answered a fundamentally same question in the community yesterday.
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:
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])
)
)
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])
)
)
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
I could have simplified the workflow by generating rows starting from Record=4, but this deduplication step was fun to implement though
Forced myself to use an iterative macro approach since I tend to avoid, good learning experience
