I have a 02 SharePoint lists, Total Budget and Invoice list. In the Total Budget list I have the budgets allocated to each section. What I need to do is, when an invoice amount is added to the Invoice list, it should be deducted from the Total Budget list and the balance should be displayed in the Balance Column in Total Budget list. Is this possible?
I am using SharePoint 2013 online version. Any inputs would be helpful. Thank you :)