9 Replies Latest reply: Mar 9, 2016 9:53 AM by Richard Caliari RSS

    How to create running budget remaining

    Richard Caliari

      I have an expense report that lists expenses by account. Each account has an associated budget. How can I create a running 'budget remaining' column? An example of what I'd like to get is:

       

      Account    Budget    Expense Item    Expense Amount     Budget Remaining

      1234       $4,000    XYZ               $1,000               $3,000

      1234       $4,000    ZYX               $1,500               $1,500

      2345       $5,000    ABC               $2,000               $3,000

      2345       $5,000    BCD               $1,250               $1,750

      ...