Forum Discussion
FIFO Inventory Formula Challenge
To revel my second anniversary as a member of this EXCELlent Community, I hereby proffer this challenge to season your array manipulation skills. Perhaps, keenadvice mathetes Riny_van_Eekelen PeterBa...
It was all going so well! Because the formulae used in the calculation prevented the function being called with the array of 5 products, I set out to use recursion to build the solution array.
This involved a wrapper function FOREACH that builds the recursion stack and XSTACK that extracts results following the return from each level.
I returned the array of inventory values as required. Then I tried to SUM the amounts directly. It turns out that the result is not recognised as an array, despite the fact that it may be output as an array.
Any ideas?
