Probably the contract table. That's simplest, and I think is also the best information. You can see the state of all your contracts in one spot. Putting it directly in the load list table as a running total (kind of like a bank balance after each transaction) would take some different math. I think you'd need a date/time stamp column and have the SUMIFS formula also test for just loads that were prior to the current load. It gets complicated. |