Iterative Macro Not Utilizing All Data

[Wcasey113]

Hello all,

First time posting and first time trying to utilize/understand an iteration macro. I am attempting to utilize the FIFO Stock Aging macro kindly provided by T_Willins previously in the community forums.

The macro works until... it doesn't. My example scenario.

I would expect the below results:

However, the data is excluding the purchase from 2/28/2022. Results:

Can you tell me why this is? What the solution would be? Any insight would be greatly appreciated as I hope to use this tool for a function with a larger data set.

I have attached the workflow and macro. The issue occurs in the red container box dataset.

Thank you once against for your assistance and time.

[apathetichell]

Without where this error occurs - we can't recreate the error - so the best advice would be "see if Amp is on - and if so turn off AMP"