Problem with SUM function

[viki1967]

Good afternoon to everyone.

I write this page htm with JavaScript code:

<script language="javascript" type="text/javascript">
<!--
 
function parseNumber(val)
{
  val = parseFloat(val);
  if (isNaN(val)) return(0.0);
 
  return(val);
}
 
var idList = [630, 631, 632, 633, 634, 635, 636, 637, 638, 639, 640, 641, 642, 643, 644, 645, 646];
 
function calcola(frmObj, id)
{
 
  var sum1 = 0.0, sum2 = 0.0;
 
  for ( var n = 0 ; n < idList.length ; n++ )
    {
      sum1 += parseNumber(frmObj["BANCO-" + idList[n]].value);
      sum2 += parseNumber(frmObj["TAVOLI-" + idList[n]].value);
    }
 
  frmObj["TOT_BANCO-" + idList[0]].value = sum1.toFixed(2);
  frmObj["TOT_TAVOLI-" + idList[0]].value = sum2.toFixed(2);
}
 
// -->
</script>        
 
      <td><input type="text" name="BANCO-630" size="5" value="33,18" onkeyup="calcola(this.form, 630)"></td>    
      <td><input type="text" name="TAVOLI-630" size="5" value="128,73" onkeyup="calcola(this.form, 630)"></td> 
      <td><input type="text" name="TOT_BANCO-630" size="5" value="902,63" readonly></td>
      <td><input type="text" name="TOT_TAVOLI-630" size="5" value="1961,92" readonly></td>
 
      <td><input type="text" name="BANCO-631" size="5" value="0" onkeyup="calcola(this.form, 631)"></td>    
      <td><input type="text" name="TAVOLI-631" size="5" value="6,5" onkeyup="calcola(this.form, 631)"></td> 
      <td><input type="text" name="TOT_BANCO-631" size="5" value="0" readonly></td>
      <td><input type="text" name="TOT_TAVOLI-631" size="5" value="0" readonly></td>
 
 

The script works in this way if updated quantity :

TOT_BANCO-630 = BANCO-630 +/- BANCO-631
TOT_TAVOLI-630 = TAVOLI-630 +/- TAVOLI-631

This script not return errors but the new sum are wrong.

Link of the page:
http://www.episunneo.net/venduto.htm

Help me please.
Viki

[viki1967]

Hi everyone.

I have problem whit this function:

function calcola(frmObj, id)
{
 
  var sum1 = 0.0, sum2 = 0.0, sum3 = 0.0;
 
  for ( var n = 0 ; n < idList.length ; n++ )
 
    {
 
      sum1 += parseNumber(frmObj["BANCO-" + idList[n]].value);
      sum2 += parseNumber(frmObj["TAVOLI-" + idList[n]].value);
 
      sum3 += parseNumber(frmObj["TOT_BANCO-" + idList[n]].value) + 
              parseNumber(frmObj["TOT_TAVOLI-" + idList[n]].value);          
 
    }
 
  frmObj["TOT_BANCO-" + idList[0]].value = sum1.toFixed(2);
  frmObj["TOT_TAVOLI-" + idList[0]].value = sum2.toFixed(2);
  frmObj["TOT_SENZA_IVA-" + idList[0]].value = sum3.toFixed(2);
 
  var vl = frmObj["TOT_CON_IVA-" + idList[0]].value = sum3.toFixed(2) * 0.1 +
                                                      parseNumber(frmObj["TOT_SENZA_IVA-" + idList[0]].value);
 
  frmObj["TOT_CON_IVA-" + idList[0]].value = vl.toFixed(3);                                                      
 
 
}
 

The link of the page web:
http://www12.asphost4free.com/viki1967/venduto.htm

Try change values line number 4:

BANCO = 3
TAVOLI = 3
TOTALE SENZA IVA = 1165.37 ???? its wrong

BANCO = 3.3
TAVOLI = 3.3
TOTALE SENZA IVA = 1155.40 !!!! its OK

Was going on ?

Can you help me?

[acoder]

You're only setting the total for 630. Do you need to update for all totals?

[acoder]

Since this is related somewhat to the first problem, I've merged the two threads.

[viki1967]

You're only setting the total for 630. Do you need to update for all totals?

Yes, I don't have it any problem, thanks:

http://www12.asphost4free.com/viki1967/venduto.htm

[acoder]

Does that mean it's working now?

If not, the figures that you mention don't match with the default values.

[viki1967]

Can you give me a example please?

[acoder]

I meant this:

Try change values line number 4:

BANCO = 3
TAVOLI = 3
TOTALE SENZA IVA = 1165.37 ???? its wrong

BANCO = 3.3
TAVOLI = 3.3
TOTALE SENZA IVA = 1155.40 !!!! its OK

The figures are something else, so I can't be sure what's right or what's not unless I manually sum the fields.

[viki1967]

I meant this:

The figures are something else, so I can't be sure what's right or what's not unless I manually sum the fields.

Line 4:

BANCO = 3
TAVOLI = 0
TOTALE SENZA IVA = 2801.8

BANCO = 3.3 ( +0.3 )
TAVOLI = 3.3 ( +3.3 )
TOTALE SENZA IVA = 2805.4

2801.8 + 0.3 + 3.3 = 2805.4

It's OK ?

[acoder]

That looks about right, so it's working. What changes did you make?

[viki1967]

The lines 19 and 20 :

function calcola(frmObj, id)
{
 
  var sum1 = 0.0, sum2 = 0.0, sum3 = 0.0;
 
  for ( var n = 0 ; n < idList.length ; n++ )
 
    {
 
      sum1 += parseNumber(frmObj["BANCO-" + idList[n]].value);
      sum2 += parseNumber(frmObj["TAVOLI-" + idList[n]].value);
 
 
 
    }
  frmObj["TOT_BANCO-" + idList[0]].value = sum1.toFixed(2);
  frmObj["TOT_TAVOLI-" + idList[0]].value = sum2.toFixed(2);
 
  sum3 = sum1 + sum2;    
  frmObj["TOT_SENZA_IVA-" + idList[0]].value = sum3.toFixed(2);
 
 
  var vl = frmObj["TOT_CON_IVA-" + idList[0]].value = sum3.toFixed(2) * 0.1 +
                                                      parseNumber(frmObj["TOT_SENZA_IVA-" + idList[0]].value);
 
  frmObj["TOT_CON_IVA-" + idList[0]].value = vl.toFixed(3);                                                      
 
 
}
 

Replace this:

sum3 += parseNumber(frmObj["TOT_BANCO-" + idList[n]].value) + 
        parseNumber(frmObj["TOT_TAVOLI-" + idList[n]].value); 
 

whit:

  sum3 = sum1 + sum2;    
frmObj["TOT_SENZA_IVA-" + idList[0]].value = sum3.toFixed(2);
 

[acoder]

Thanks for posting and glad it's working!

[viki1967]

You are welcome and I'am very happy to found this Community!