Quick help with an Iterative Macro

WestonProhaska

Hi All, 

I'm struggling needlessly on an iterative macro example. I know I'm missing something super simple and it's driving me nuts. 

Essentially, I have data like below:

2014	2015	2016	Start %	End %	Increment
.4	.4	.4	.4	.2	.05

1. I want the macro to loop through the data subtracting Increment from 2014 until it's equal to end% 

-I have the loop feed conditioned via filter of "[2014] = [End %] with the false side being looped to the iterative output. A formula tool doing the subtraction prior to the filter. 

-I would think this is sufficient to loop through and subtract repeatedly until it gets to .2. However, it keeps erroring out.

2. Is it also possible to output each of the iterations until it gets there?

I've also attached the sample of what I tried to do

Thanks in advance

Test Iterative.yxzp

kathleenmonks

Hi @WestonProhaska,

For some reason, I think the filter is not catching that they are ever equal which is probably due to some weird rounding with doubles. If you change your filter to be: Round([2014], 0.01) = Round([End %], 0.01) then the macro should exit after 4 iterations. Let me know if this works!