Skip to Content
author's profile photo
Former Member

Advanced layout: ho to calculate total of a columns

I've a column in a table that has the price of the lines, but i want to calculate the total of all the lines, how can i do it? Is there any function that do this? Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 05, 2005 at 12:24 PM

    Hi Miguel

    You need to create a Sum Variable (Project > Sum Variables). The Sum Variables sums over DocumentLine.Row_Total (or whichever field you want to total). <b>Put the variable in a Footer Line</b>.

    Regards

    Danie

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 05, 2005 at 10:39 AM

    Miguel, could you be more specific?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ok, i've an invoice form, and i show all the lines of the invoice: itemcode(1), itemprice(2), quantity(3) and linetotal(4).

      When i end showing all the items, i want to calculate the total sum of the fields linetotal(4).

      In the printlayout, there was a calculation called column sum that did it, but in advanced layout i don't know how to do this. Any idea?