Announcement

Collapse
No announcement yet.

How insert additional total that makes sum(col A) - sum(col B)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How insert additional total that makes sum(col A) - sum(col B)

    Dear all,

    I've a grid with 1 credit column (amount_in) and 1 debit column(amount_out) . Values are update within the grid where you record cash in and cash out entries.
    Totals work nice but it gives me only each column total. I need also a balance calculation.

    Now in the grid report I would like to add a dinamic new total which makes the balance between the sum of two above columns.

    Balance = amount_in_sum - amount_out_sum

    Any suggestions would be very appreciated
    Bye
    Giovannino


    Attached Files

  • #2
    Originally posted by giovannino View Post
    Dear all,

    I've a grid with 1 credit column (amount_in) and 1 debit column(amount_out) . Values are update within the grid where you record cash in and cash out entries.
    Totals work nice but it gives me only each column total. I need also a balance calculation.

    Now in the grid report I would like to add a dinamic new total which makes the balance between the sum of two above columns.

    Balance = amount_in_sum - amount_out_sum

    Any suggestions would be very appreciated
    Bye
    Giovannino
    I have the same problem, did you solved it ?
    Thanks
    Fabrizio

    Comment


    • #3
      Have you tried to use the detail page? You can display that by default below the grid. I don't know when the detail is being updated though, so it might be necessary to calculate the balance on forehand and save that to a global variable.
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


      • #4
        why wouldnt you create a new field, and just assign the calculation to the new field..
        then add that to the summary...

        Comment


        • #5
          That's by far the easiest way..
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment

          Working...
          X