Grouped Running Total Method |Power Query|Excel Forum|My Online Training Hub

Hello! Newbie over here...

I mishmashed the code from the running totals post and the grouped running post and came up with the code below to do a grouped running total, yet it seems to reset each time it hits a 0 value. Any idea as to why?

Thank you for all the help beforehand!

let
Source = Table.Combine({CITIBank_USDChecking, QNBFinansbank_TRYMevduat}),

...steps in between

#"Reorder Cols" = Table.ReorderColumns(#"Added Custom ""Category"" Col",{"Account", "Currency", "Date", "Num", "Payee", "Description", "Tag", "Category", "Clr", "Debit", "Credit"}),

BufferValues = List.Buffer (#"Reorder Cols"[Debit]) ,

BufferGroup = List.Buffer (#"Reorder Cols"[Account]) ,

runTotal = Table.FromList (
fxGroupedRunningTotal ( BufferValues , BufferGroup ) , Splitter.SplitByNothing() , {"runTotal"}
),
combineCols = List.Combine ( {
Table.ToColumns(#"Reorder Cols") , Table.ToColumns(runTotal)
} ),

#"Convert to Table" = Table.FromColumns (
combineCols,
List.Combine ( { Table.ColumnNames(#"Reorder Cols") , {"runningDebit"} } )
)
in
#"Convert to Table"