Hi!
I am doing a stock rotation report for my Company which basically displays an Age Profile (How long since stock was created) of both Stock on the Ground and Stock Despatched in the past day.
I would like to do a formula beside this table (Will attach image showing example) that returns the amount of product that could have been sent that is older than the product that was actually sent. I have tried a few times, but just cannot seem to get the logic to work how I want it to work.
Happy to provide further information if you need it.
Thank you if anyone is able to assist
I am doing a stock rotation report for my Company which basically displays an Age Profile (How long since stock was created) of both Stock on the Ground and Stock Despatched in the past day.
I would like to do a formula beside this table (Will attach image showing example) that returns the amount of product that could have been sent that is older than the product that was actually sent. I have tried a few times, but just cannot seem to get the logic to work how I want it to work.
Happy to provide further information if you need it.
Thank you if anyone is able to assist