Iterative Macro not working.

[subhajits11]

I am trying to practice and done these exactly the same as in this video https://community.alteryx.com/t5/Videos/Build-Your-First-Iterative-Macro/m-p/55565

And here is my workflow ,but i not able to fine a single reason for not happening iteration.

If anyone can help !

here I have attached the file.

[danilang · Accepted solution]

Hi @subhajits11 

The problem in your macro is that the formula creates a new field called [Total Amount]=[Money]*2.

On each iteration this is always equal to 0.02, since [Money] never changes.

Change your formula to [Money]=[Money] * 2.  With this [Money] will double on each iteration 0.02 on iteration 1, 0.04 on iteration 2, 0.08 on iteration 3, etc.

Dan

[subhajits11]

This was simple and i had this understanding issue .

Now i know the reason ,Thanks to you @danilang