Thread: Running total automated
View Single Post
 
Old 03-15-2017, 06:19 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
If you are always taking away the same quantity, then it's fairly easy.

End_qty=Start_qty-Deduct_qty*(Today()-Start_date)
Reply With Quote