[Leenomeedo]

Hi
I have so issue in grid , I have grid contents of 3 columns debit ,credit and balance I have tried and searched but I failed .
How can I implement and calculate balance as formula balance=(balance+credit)-debit and finally the total summary at the bottom the fraction rounded to 2 digits eg. 12344.25
(find attached the dynaform)

[amosbatto]

Do you want balance to be a running calculation that sums from the balance in the previous row in the grid like this?

Row1: balance1 = credit1-debit1
Row2: balance2 = (balance1+credit2)-debit2
Row3: balance3 = (balance2+credit3)-debit3
Row4: balance4 = (balance3+credit4)-debit4
summary = balance4

Or do you want something do different?

[Leenomeedo]

Yes exactly what I want how do I do that in code?

[amosbatto]

I created a programming example to explain this. See:
https://sourceforge.net/p/pmcommunity/c ... countGrid/

[Leenomeedo]

Its very helpful example I am really thank you for your support

I created a programming example to explain this. See:
https://sourceforge.net/p/pmcommunity/c ... countGrid/