How to Multiply Table Inputs

Question

I'm having issues multiply two columns of a table, outputing the result in to the 3rd column, then adding the totals into the subtotal.

I've got it where it can ADD the input fields but not MULTIPLY. Below is a jsFiddle where I attempt to multiply but it doesn't work

I assume that the issue has to do with multiplying by zero, but I'm not sure exactly where I am going wrong

My code:

$('table input').on('input', function() {
  var $tr = $(this).closest('tr');
  var total = 0;
  $('input:not(:last)', $tr).each(function() {
    total *= Number($(this).val()) || 0;
    console.log(total)
  });
  $('td:last input', $tr).val(total);
  subTotalPrice();
}).trigger('input');


function subTotalPrice() {
  var total = 0;
  $(".amount").each(function() {
    total += parseFloat($(this).val() || 0);
  });
  $("#subTotalResult").text(total);
}





  
    
      
        From Our Smoker
      
    
    
      
        Menu Items
      
      
        Servings
      
      
        Per Servings
      
      
        Ext Cost
      
    
    
      
        
          
          
            
        BBQ Beef Brisket
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Pulled Pork
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Boneless/Skinless Chicken Breast
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Smoked Leg Quarter
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        1/2 Cornish Hen
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Buffet Ham
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Mild or Hot Links in BBQ Sauce
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        BBQ Pork Spareribs
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Bratwurst
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        Subtotal for "From our Smoker" :
      
      
        
      0.00

Barmar · Accepted Answer

If you're multiplying a series of numbers, you need to initialize the product with 1, not 0. Multiplying by zero produces zero, multiplying by one produces the same value.

You should also use toFixed() to discard extra fractional digits that often occur when dealing with floating point numbers.

You also had a typo: maxlenght should be maxlength.

$('table input').on('input', function() {
  var $tr = $(this).closest('tr');
  var total = 1;
  $('input:not(:last)', $tr).each(function() {
    total *= Number($(this).val()) || 0;
  });
  $('td:last input', $tr).val(total.toFixed(2));
  subTotalPrice();
}).trigger('input');


function subTotalPrice() {
  var total = 0;
  $(".amount").each(function() {
    total += parseFloat($(this).val() || 0);
  });
  $("#subTotalResult").text(total.toFixed(2));
}





  
    
      
        From Our Smoker
      
    
    
      
        Menu Items
      
      
        Servings
      
      
        Per Servings
      
      
        Ext Cost
      
    
    
      
        
          
          
            
        BBQ Beef Brisket
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Pulled Pork
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Boneless/Skinless Chicken Breast
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Smoked Leg Quarter
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        1/2 Cornish Hen
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Buffet Ham
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Mild or Hot Links in BBQ Sauce
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        BBQ Pork Spareribs
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        
          
          
            
        Bratwurst
       
          
        
      
      
        
        
      
      
      
        
      
      
      
        
        
      
      
      
        
      
    
    
    
      
        Subtotal for "From our Smoker" :
      
      
        
      0.00

How to Multiply Table Inputs

Answers (1)

Related Questions