I need to be able to produce numbers based on an ageing cycle.
I have as an example, a table that contains data for a stock item, as per the attached spreadsheet
The date is the date of the stock movement, the status is either I or O (In or Out), the Qty In and Qty Out are self explanatory. I have a current physical stock of 108. I need to be able to determine how old this physical stock is and break it down into specific periodic groups as follows:
So based on todays date and the periodic groups, report the number of stock items from the physical stock.
I hope that makes sense!