RemainingBalance to show on Source Sheet
Hello All! What is the best way to maintain a remaining balance? In my scenario, I want to show the remainng balance after each new invoice record.
I tried the following in the Remaining Balance field:
=[PO# Award Amntt]@row - SUMIFS([Inv. Amnt]:[Inv. Amnt], Vendor:Vendor, =Vendor@row, [FYar]:[FY], =[FY]@row, [P.O. #]:[P.O. #], =[P.O. #]@row)
This is what I get:
Help Article Resources
Check out the Formula Handbook template!