How to sum render data

qqww

i need to sum data from render: "[].ves" now its look like 90,60 i need in this case 150. Sorry for english.

my code:

->join(
    Mjoin::inst( 'chast' )
        ->link( 'razdelka.id', 'chast.razdelka' )
        ->fields(
           Field::inst( 'ves' )
        )
)

client:

columns: [
{ data: "chast", render: "[].ves" }
]

Help me! i weaste all day.

allan

You need to use columns.render as a function - for example:

{
  data: 'chast',
  render: function ( d ) {
    var sum = 0;
    for ( var i=0 ; i<d.length ; i++ ) {
      sum += d[i].ves;
    }
    return sum;
  }
}

Allan

qqww

Thanks for reply!

i try to use you example, and they return me 09060 (before i put 90 and 60), not sum

allan

That suggests that ves is a string. You'd need to cast it as a number. You can do that simply by using: d[i].ves*1.

Allan

qqww

thanks Allan!