Answers

• kthorngren Posts: 22,310Questions: 26Answers: 5,128

  November 2 Answer ✓

  You can either use Javascript toFixed() or chain .display( .... ) to the number renderer like this:

  return DataTable.render.number(null, null, 2).display( data.reporting_header.balance_CLBD_amount_amount );
  

  AFAIK the .display( ... ) method is undocumented. I remember it from an old thread.

  Kevin
• allan Posts: 65,298Questions: 1Answers: 10,826 Site admin

  November 3

  It is yes. The number renderer is handy for dealing with multi-locale tables (i.e. displaying in the locale format that the end user would expect), but if you just want some simple formatting like fix precision, then toFixed() would be the way to do it.

  Allan
• carrarachristophe Posts: 125Questions: 29Answers: 2

  November 3

  Dear both,
  thanks for your prompt reply. I applied it that way and it looks like it worked like a charm:

  {data: null, render: function ( data, type, row ) {
       if (data.reporting_header.balance_CLBD_credit_debit_indicator === 'DBIT') {
            return DataTable.render.number(null, null, 2).display( -1 * data.reporting_header.balance_CLBD_amount );
       } else {
            return DataTable.render.number(null, null, 2).display( data.reporting_header.balance_CLBD_amount );
            }
       }
  }