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.
