General Discussions
Discuss any topics that are not product-specific here.
Got it! I screwed up on my initial RegEx and dropped the negative signs. I ended up rebuilding the workflow 3 times and the macro twice (thanks @phottovy (again) for posting your workflow - it helped affirm I was doing the dang workflow right), getting the same wrong answer every time (which was frustrating at the time, but now makes me feel better) before finally catching the RegEx error. I'm going to sit and stare at a wall for awhile :)
Fun and quick challenge today - gave time to catch up on day 5 :-)
There's a trick to this one too
Spoiler
The trick here is that you don't need to keep all the data - the pyramid can be as wide as you like, it doesn't matter
You just need to keep (for every row other than the top row) the first and the last values - and that gives you part 1 and part 2
The iterative macro below goes across the first row - and you can go downwards to the bottom of the pyramid with a multi-row
You just need to keep (for every row other than the top row) the first and the last values - and that gives you part 1 and part 2
The iterative macro below goes across the first row - and you can go downwards to the bottom of the pyramid with a multi-row
seem like i built the shortest macro. but lot of dynamic rename involved.
Spoiler
part1: forget the "-" was in the number
part2: try to use sum method as part1 not working. changed as instruction show.
workflow
macro
part2: try to use sum method as part1 not working. changed as instruction show.
workflow
macro
