title: DataTables, calculated column
body: <p>I am trying to create a column in my table using the DataTable plugin, that is calculated using values from two previous columns.</p>
  
  <p>Something like this.. <em>(Price)(QTY)=Total</em></p>
  
  <pre><code>|| Price || QTY || Total||
  ==========================
  ||  5    ||  2  ||  10  ||
  ||  10   ||  3  ||  30  ||
  ||  4    ||  1  ||  4   ||
  </code></pre>
  
  <p>I feel like it should be simple, but I can't get it to work. <a href="https://datatables.net/forums/discussion/25675/how-to-display-computed-column-dynamically-using-jquery-datatables" rel="noreferrer">Here is a similar question I tried to follow.</a></p>
  
  <h2>Here is my JS file where I am initializing the table</h2>
  
  <pre><code>var table = $('#tempPOs').DataTable( {
          dom: 'frtip', //Bfrtip (removed the B to get rid of the buttons)
          ajax: '/inventory/DTResources/php/table.tempPOs.php',
          columns: [
          { "data": "pmkPart" },
          { "data": "PartNumber" },
          { "data": "Description" },
          { "data": "fnkManufacturer" },
          { "data": "Notes" },
          { "data": "EachPrice", render: $.fn.dataTable.render.number( ',', '.', 0, '$' ) },
          { "data": "Quantity" },
          { "data": "Username" },
          {
              data: null,
              className: "center",
              defaultContent: '&lt;a href="" class="editor_remove"&gt;Remove&lt;/a&gt;'
          }
          ],
          select: true,
          lengthChange: false,
          buttons: [
          { extend: 'create', editor: editor },
          { extend: 'edit',   editor: editor },
          { extend: 'remove', editor: editor }
          ],
  
      } );
  </code></pre>
  
  <h2>Here is my HTML</h2>
  
  <pre><code>&lt;th&gt;Part ID&lt;/th&gt;
  &lt;th&gt;Part Number&lt;/th&gt;
  &lt;th&gt;Description&lt;/th&gt;
  &lt;th&gt;Manufacturer&lt;/th&gt;
  &lt;th&gt;Notes&lt;/th&gt;
  &lt;th&gt;Part Price&lt;/th&gt;
  &lt;th&gt;Quantity&lt;/th&gt;
  &lt;th&gt;Username&lt;/th&gt;
  &lt;th&gt;Total Price&lt;/th&gt;
  &lt;th&gt;Remove&lt;/th&gt;
  </code></pre>
  
  <p>Anyone able to point me in the right direction?</p>