Hi,
I'm struggling to get something to work: I have a report in Zoho Creator with the following Columns:
Property Date Category Credit Debit Delta
The first five columns are from data entered into the DB, the sixth column, "Delta" is from an aggregate formula where I effectively minus Debit from Credit:
sum("Autoview_1445830633762_Morse_General_Ledger Table"."Debit")-Sum("Autoview_1445830633762_Morse_General_Ledger Table"."Credit")
What I want is for the Balance Column to be a running total. But when I select running total - nothing changes...the amount stays the same...
Can anyone help?
Screen shot below.