racingvalue

Thanks for the reply guys.

Hi ericc44, I have added the footer and added this code but still see the !ERROR! Circle Reference, is this correct or did i miss something?

“footerCallback”: function( row, data, start, end, display ) { var api = this.api(), data; var intVal = function ( i ) { return typeof i === ‘string’ ? i.replace(/[\$,]/g, ”)*1 : typeof i === ‘number’ ? i : 0; }; total = api .column( 1, { page: ‘current’} ) .data() .reduce( function (a, b) { return intVal(a) + intVal(b); }, 0 ); $( api.column(1 ).footer() ).html( total ); $( api.column( 2 ).footer() ).html(‘Totals :’); }

Thanks

Hi Tobias,

I am just wondering is it possible to SUM just the visible rows which have been filtered.

I get this error:

!ERROR! CIRCLE REFERENCE

Thanks

Hi Tobias,

I am trying to show only the header and 10 rows without the footer as you can in the image how would i go about doing that?

Thanks

• This reply was modified 7 years, 9 months ago by racingvalue.

Great got it sorted thanks ??

Just have one more question if you dont mind, if i use the AUTOSUM feature is there anyway i can change the font color to like +10.00 green and -10.00 red? when i do it the AUTOSUM doesn’t work then.

Thanks

Great thanks very much.

Perfect!

Just one more thing is there any way to autosum say column G automatically when a new row is added from G2 onwards instead of editing the “=NUMBER_FORMAT( SUM( G2:G4 ), 2 )” each time?

Thanks ??