I'm in need of some assistance with calculating running balances in the script. I've attached a sample qvw, sample data (Book1.xlsx), and the result that I'm trying to acheive (FinalResults.xlsx). The NewRunTotal column (in FinalResults.xlsx) is the running balance that I'd like to get to.
Any pointers on how to accomplish this would be greatly appreciated.
