I am looking for some insight as to how to go about building a formula that will allow me to age on hand balances. IE: Total on hand = 100 Purchase history by month: 2 in July, 6 in June, 50 in April, 50 in March. If aged the balance in March needs to be 2. Any assistance would be greatly appreciated.
Sherie
Bookmarks