This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'd like to trace deposits using the last in, first out (LIFO) approach. Essentially, I need to deplete the deposit amount with any subsequent withdrawals unless a new deposit comes in, and I'd deplete the new deposit first before returning back to the older deposits. I attached a sample dataset along with an example. Please note that I do not need the format of workflow output to mimic the example.
Please let me know if I can clarify anything. Thank you in advance for your help with this matter.
I've reviewed the posts and have successfully built a workflow for the same dataset for FIFO. However, I am having trouble with determining the tools to use to stop depleting a deposit if a new deposit comes in.
If you need any additional information, please let me know.
I built the attached workflow for my LIFO analysis. Containers 297 & 298 can be set up as an iterative macro, but haven't gotten around to build it. Depending on the size of the data I run through, I'll copy those two containers to accommodate all the data.