Running Balance per Transaction

I'm interested in running balance calc too.
At my end it'd be laid out like this:

Deposits   |   Withdrawals   |   Running Balance
                                                               100.00
100.00                     0.00                        200.00
100.00                   50.00                        250.00

Great Derek!

It does apply to my project. 

Thank you so much!

Thanks Derek!

Appreciated!

You'll be my guest and see soon in the Philipines!

Hi Manixs,
I was able to recreate what you found but I don't quite know how to fix it. 
I think it might be a bug so I have messaged Dmitry and asked him to have a look at it.
If he can't find a solution, a way around it is to use 2 separate fields - 1 date field and 1 time field (rather than use a combined date/time field).
I will get back to you when I've had an answer.
Regards,
Derek.

Hi Derek and Manixs,

My apologies for not making my layout clear. I should have added additional two columns (cost of deposit and cost of withdrawal)  in addition and show deposits and withdrawal in separate columns. At my end I wanted to use running balance in banking terms.

Manixs' calc field formula with printf("%.2f",... seems to be working OK. Thanks for sharing Manixs.

When formatting tGrid cell values with decimals and thousand separator;
the following works fine without printf("%.2f",...  calc fields and on form calcs:

procedure Form1_tgMain_OnChange (Sender: string);
begin
 if form1.tgMain.Columns[4] is TNxNumberColumn then
    begin
    TNxNumberColumn(form1.tgMain.Columns[4]).FormatMask := '#,###,##0.00'; //
    TNxNumberColumn(form1.tgMain.Columns[6]).FormatMask := '#,###,##0.00'; //
   end;
end;

However, the above didn't work with calc field containing printf("%.2f",...
I found out that old method below worked with calc field containing printf("%.2f",...

procedure Form1_tgMain_OnChange (Sender: string);
var i,c: integer;
begin
    Form1.tgMain.BeginUpdate;

    c := Form1.tgMain.RowCount - 1;
    for i := 0 to c do
    begin
        Form1.tgMain.Cells[8, i] := FormatFloat('#,##0.00', Form1.tgMain.Cell[8, i].AsFloat);
        Form1.tgMain.Cells[9, i] := FormatFloat('#,##0.00', Form1.tgMain.Cell[9, i].AsFloat);
    end;
    Form1.tgMain.EndUpdate;
end;

Just wanted to share in case others may encounter the same issue and also for correction if needed.

Hi Manixs,
The 'time' part of datetimepicker needs to be set up as the primary element and defined as your database field, not the 'date' part as I was doing. 
You then associate the 'date' element (undefined)  with the 'time' element.  I hope that makes sense.
I've attached the original project with it fixed (even though I see that you've now got it working by using separate date and time fields).
Regards,
Derek.

Hello to All!

Pls help me to solve my problem.  I need to color the rows of all identified as Paid Out.

Thank You!