title: How to format currency in Datatables?
body: <p>This is a table which display transactions, implementes using <a href="https://datatables.net/" rel="nofollow noreferrer">DataTables</a>.
  <a href="https://i.stack.imgur.com/lJAYe.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lJAYe.jpg" alt="enter image description here"></a></p>
  
  <pre><code>$( document ).ready(function() {    
      var table = $('#tbl_transaksi').DataTable( {
          "ajax": "data_transaksi.php",
          "bPaginate":true,
          "bProcessing": true,
          "pageLength": 10,
          "columns": [
              { mData: 'username' } ,
              { mData: 'fullname' },
              { mData: 'the_date' },
              { mData: 'amount',  render: function ( data, type, row ) {
                  return "Rp " + data;
                  } 
              }
          ],
          "dom": 'Bfrtip',
          "buttons": [
              'copy', 'csv', 'excel', 'pdf', 'print'
          ]
      }); 
  
  });
  </code></pre>
  
  <p>It works. Now I want to add an enhancement: format the amount ("jumlah") using Indonesian format, so for example <strong>1000000</strong> will be displayed as "<strong>Rp 1.000.000</strong>";</p>
  
  <p>A Google search pointed me to <a href="https://datatables.net/manual/data/renderers#Number-helper" rel="nofollow noreferrer">renderers</a>. I added the render part into my code, and well it doesn't change the formatting. What is wrong here?</p>