+1 800 256 3608 (toll-free in North America) or +49 7531 90 60 10| service@combit.com

Running Totals in Tables


(Vajesh Durbal) #1

Hello,

we are trying to do a running total in a table. For example:
Field 1: name with data rows of EXAMPLE, EXAMPLE 1, EXAMPLE 2, EXAMPLE 3, EXAMPLE 4
Field 2: amount with data rows of 1, 5, 10, 15, 20

Want to have a table like this:

Name Amount
EXAMPLE 1
1

EXAMPLE 1 5
6

EXAMPLE 2 10
16

where first amount row is the amount from the EXAMPLE data row and the second row under amount is the running total. I’ve tried groupings and sub groupings, several different user variables, etc. and can not figure this out. Do you have any suggestions? Thank you.

Vijay


(combit Support - Christian Rauchfuß) #2

Hello Vijay,

thank you for your post.

A design like this is possible. All you need is one header line, one data line and a grouping (group footer). Within the header line you just print the column names “NAME” and “AMOUNT”. Within the data line you print the fields themselves

. and
.. The running total needs to printed within a group footer. The formula should look like this:
Sum(Tabelle1.AMOUNT,false)

To print the running total for each data record just set the “Group By” property of the line definition in the group footer to <TABLE.NAME>. See attached screenshots for more details.

Best regards,

Christian Rauchfuß
Technical Support
combit GmbH

runningTotal2.png