is There any way to Create View to sum Total Running Balance (Credit debit)
My Query running well, but I can not save in View or Compile to PHPRunner.
------------------------------------------------------------------------------
set @balance := 0;
SELECT TransactionNumber, Account, Date, debet, Kredit, (@balance := @balance + (debet - Kredit)) as Balance, Remark
FROM financetransaction where account = 3
ORDER BY Account, date;
group BY Account, date, TransactionNumber
-------------------------------------------------------------------------------
Thanks in advance.
