Multiply values and apply style in Datatables

ADuslon

Dear community,
I would like to understand how to multiply column values and apply style in Datatables.

Currently my columns section looks like this :

"columns": [
{ data: "id" },
{ data: "brand" },
{ data: "description" },
{ data: "nb_ref" },
{ sortable : false, data: "cost", render: $.fn.dataTable.render.number( ' ', '.', 2, '€' ) },
]

what I would like in the 5th column is to multiply the "cost" by the "nb_ref" (the value of the 4th column) and still apply the number format.

Any idea about how to achieve ?

thanks

Adam

colin

You would need to have a function for columns.render - third parameter will be the data for the entire row. You would then need to format it as a number within that function.

return $.fn.dataTable.render.number(',', '.', 0, '$').display(sum);

This thread has an example of that.

Colin

ADuslon

This is great. Thank you Colin !