Former Member

# Formula for "Balance"

Hi all experts,

How to do the formula for the balance? e.g. result show as below.

I need this for my customer statement

Dr Cr Balance

10 0 10

11 8 13

5 10 8

Thanks.

Danny

Edited by: Danny Gan on Oct 16, 2008 11:20 AM

10|10000 characters needed characters exceeded

### Related questions

• Former Member
Posted on Oct 16, 2008 at 09:28 AM

Morning,

hmm, if I have rightly understood, what you are trying to do is to subtract Cr from Dr each time and then showing it under balance?

So, what I would do is to create three formulas here. One to calculate the number of Dr, i.e. 10, 11, 5 and then create another formula which calculates Cr, i.e. 0,8,10 and then third one would be

{@formula1}-(@Formula2}

and then display it on to the report.

Do I make sense?

Regards

Jehanzeb

Dr Cr Balance

10 0 10

11 8 13

5 10 8

10|10000 characters needed characters exceeded
• Former Member Former Member

Jehanzeb you are really a Expert...Finally i get the result the result i want....

Thanks a lot

Regards,

Danny

• Former Member
Posted on Oct 16, 2008 at 11:19 AM

Hi Danny,

If Cr and Dr are straight from the DB then create a formula

Numbervar bal;

bal:=DB.Cr-DB.Dr;

And place this formula into your report.

Hope this helps!

Regards,

Vinay

10|10000 characters needed characters exceeded
• Former Member

Formula:

Numbervar bal;

bal:={JDT1.Debit}-{JDT1.Credit}

Formula u advised result is not really correct....

Debit Credit Balance

125 0 125

0 125 -125

Correct result

Debit Credit Balance

125 0 125

0 125 0