Having problem in row grouping with calculation.

ManiDhoni

Hi!
Having an issue with the rowgroup feature. Trying to add the values of a calculated column but keep getting NaN in the grouping:

 "columns": [
            {
                "render": function (data, type, full, meta) {
                    return '<td><div><span>' + full.order_date + '</span></div></td>'
                }



            },
            { "data": "facility_name" },
            { "data": "ResidentName" },
            { "data": "order_id" },
            {
                "render": function (data, type, full, meta) {
                    return parseInt(full.Value.toFixed(2))
                }, className: "Total",



            },


        ],
        order: [[3, 'asc']],
        rowGroup: {
            startRender: null,
            endRender: function ( rows, group ) {
                var totalspend = rows
                    .data()
                    .pluck(4)
                    .reduce( function (a, b) {
                        return a + b;
                    }, 0);
 
                return $('<tr/>')
                    .append( '<td></td><td></td><td></td><td>Total Spend</td>' )
                    .append( '<td>'+totalspend.toFixed(2)+'</td>' )
            },
            dataSrc: "order_id"
        },

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

ManiDhoni

Can anyone please help me to resolve this issue.

kthorngren

See Colin's example from this thread.

Kevin

ManiDhoni

Hi @kthorngren this example shows only for grouping name. can u please tell me how to calculate grouping value and bind

ManiDhoni

Hi @colin and @allen could u please help me to resolve this issue.

kthorngren

That example shows how to use cell().render() to get the rendered value of a cell. Sounds like that is what you are asking for. If you need help with an example then please start by building a test case with an example of your data so we can provide a specific solution.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

You can update Colin's example if you like, just post the new URL.

Kevin