Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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

    Add comment
    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