Hi All,
I'm struggling on an iterative macro example.
Essentially, I have data like below:
2014 | 2015 | 2016 | Start % | End % | Increment | Adjustment |
.4 | .4 | .4 | .4 | .2 | .05 | A |
,4 | .4 | .4 | .4 | .15 | .05 | B |
1. Is it possible to configure my macro to get me an output similar to something like below?
-I want to add the previously completed iteration conditions to the ones that continue onwards after finishing the condition.
Results of current macro:
2014 | 2015 | 2016 | Start % | End % | Increment | Adjustment | Scenario |
.35 | .4 | .4 | .4 | .2 | .05 | A | 1 |
,35 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.3 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.3 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.25 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.25 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.2 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.2 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.15 | .4 | .4 | .4 | .15 | .05 | B | 1 |
Results I'm looking for:
2014 | 2015 | 2016 | Start % | End % | Increment | Adjustment | Scenario |
.35 | .4 | .4 | .4 | .2 | .05 | A | 1 |
,35 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.3 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.3 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.25 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.25 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.2 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.2 | .4 | .4 | .4 | .15 | .05 | B | 1 |
.2 | .4 | .4 | .4 | .2 | .05 | A | 1 |
.15 | .4 | .4 | .4 | .15 | .05 | B | 1 |
I've also attached the sample package I put together. Thanks in advance!
Hi @WestonProhaska - You don't have to have a Macro for this use case. Attached is a possible solution for you: