OK, looking pretty good. But let me throw this in. The monthly data is actually the second group. Group 1 is a location. We have 4 inventory locations. The "accum" formula is being passed through each location group and I need to reset the accum total for each group.
I've read a couple threads on this but I think my problem may be slightly different.
I'm trying to calculate the ending inventory value for the last 12 months based on the current inventory value and net inventory activity during the last 12 months.
For example, I have a current inventory...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.