Running Total Aggregate Delivery Tracking

[KFINDLAY]

Trying to build an app that will allow me to enter the PO Qty, enter daily delivery amounts and track remaining balance to deliver. I'm having the hardest time figuring out AppSheet formulas to make this happen. Any help would be greatly appreciated.

This is what it looks like in Google Sheets.

PO#	Customer	Job Name	Awarded Date	Area	Projected Start	Status	Material	PO (Qty)	Date Shipped	Daily Qty Shipped	Total Shipped To Date	Balance
12345	Winston	Parkway Plaza	2/1/2023	MCO	2/20/2023	Shipping	Limerock	5,000.00	2/20/2023	500.00	500.00	4,500.00
									2/21/2023	600.00	1,100.00	3,900.00
									2/22/2023	400.00	1,500.00	3,500.00
									2/23/2023	500.00	2,000.00	3,000.00
									2/24/2023	600.00	2,600.00	2,400.00
									2/27/2023	400.00	3,000.00	2,000.00
									2/28/2023	700.00	3,700.00	1,300.00
									3/1/2023	300.00	4,000.00	1,000.00
									3/2/2023	700.00	4,700.00	300.00
									3/3/2023	300.00	5,000.00	0.00

[Marc_Dillon]

I suggest searching for "running total" here in this community.

[sreekar_pranav]

Can you explain me a bit more about your issue 

[KFINDLAY]

Sure. We deliver products like limestone and sand for the construction industry. Once an order amount is put into the app,  I need it to track daily delivery totals and calculate the balance of how much is left to deliver for the project.  We will be entering delivered quantities on a daily basis for multiple projects. Some large projects may take over 100 delivery days to fulfill the order. I have looked at other posts regarding running totals, but I haven't found one that fits my use case.