cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced layout: ho to calculate total of a columns

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

AlexGrebennikov
Active Contributor
0 Kudos

Miguel, could you be more specific?

Former Member
0 Kudos

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?