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.
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"