Need Help With Inventory Application in Zoho Creator

I am creating an inventory solution which captures how much of a product was consumed and produced on a particular day.

Any idea how to get the closing inventory on each day / user selected date?

Thanks