How to make a running total over all records displayed

November 27, 2019, 02:46:25 AM

Hi,

I tried everything from custom field (which does not work for linked tables).

Please assist.

Thanks.

Re: How to make a running total over all records displayed

Reply #1 – November 27, 2019, 04:12:22 PM

@kleinerr‍ this is how to use the custom field(https://www.youtube.com/watch?v=Xz_hk7-VWWM) in your case you would be using the MySQL sum() function(http://www.mysqltutorial.org/mysql-sum/) to sum two columns and display on your custom field. To do a sum of some fields displayed on the table(i.e sum total) and display result below the table, please use the FieldFooterExpression, check below for images.