Forum Discussion
Help With Creating Cumulative Total Based on Two Variables
Hi,
Your question is not clear. There are 2 instances of GL code 21650 - same number but opposite signs. In the output sheet, the negative number goes from March 1 to March 7 - Why? What result are you expecting for GL code 21671 and 21672?
Hi Ashish,
Appreciate you taking a look, and sorry for any confusion.
On March 1st, GL code 21650 had a starting credit balance (is a loan/liability acct) of -536,249.65. You are able to see a debit (positive) balance of 536,249.65 on March 8th, because that loan was paid off on that day. If you take a look at the second tab for this GL, "Desired Output," (rows 126-156), you will see what the cumulative total should look like if we found a solution in PowerQuery to get the first tab to transform into the desired result. Same thing applies with all of the other GL accounts.
Let me know if there's something else I could elaborate on further -- thanks for taking a look.
Very clever -- appreciate it!
Ashish_Mathur wrote:Hi,
You may download my Excel solution workbook from here.
Hope this helps.
