sum a column in a table [Archive]

rogers

09-22-2003, 02:36 PM

Hello,

I have a page which contains 2 forms. The second form has a table, and I want to sum the amount in the in_newfunding column for all of the rows in the table. How can that be done?

I started trying to do that in the sum_new_funding() function below. Below is the code which contains the 2 forms and the table.

Thank you.

<HTML>
<TITLE>Reallocate Funds</TITLE>
<BODY >

<script type="text/javascript">
function junk(f)
{
var rstr;
for(var i=0; i<=f.length-1; i++)
{
rstr = rstr + f.elements(i).type + " XX ";
}
document.write(rstr );
}

function sum_new_funding()
{

var tblrows=document.getElementById("tasktable").getElementsByTagName("TR");

var sum_amt = 0;

for(var i=0; i<tblrows.length; i++)
{

sum_amt = sum_amt + tblrows[i].childNodes[0].innerHTML;

)
}

</script>

<FORM ACTION="rshah.PROJECT_SETUP_MODS.reallocate_funds_acrn" METHOD="POST">
<input type="hidden" name="in_projid" value="340">

<SELECT name=in_acrnprojid onChange="form.submit();">
<OPTION VALUE=> -Select ACRN-<OPTION VALUE="3952">001<OPTION VALUE="3971">0011<OPTION VALUE="3972">0012<OPTION VALUE="3959">002<OPTION VALUE="3958">00G1<OPTION VALUE="3964">00R1<OPTION VALUE="1845">01AB<OPTION VALUE="1491">01AE<OPTION VALUE="1685">01AG<OPTION VALUE="1492">01AH<OPTION VALUE="1489" SELECTED>01AJ</SELECT>
<BR>
</FORM>
<BR>
<BR>
<HR>
<BR>
<BR>
<FORM ACTION="rshah.PROJECT_SETUP_MODS.reallocate_funds_submit" METHOD="POST">
<BR>
<table id="tasktable" align="center" cellspacing="0" cellpadding="20" border="2">
<TABLE ALIGN="center">
<TR>
<TD><font color=red>Existing</font></TD>
<TD><font color=red>Project</font></TD>
<TD></TD>
<TD><font color=red>Current</font></TD>
<TD><font color=red>New</font></TD>
<TD><font color=red>Change</font></TD>
</TR>
<TR>
<TD><font color=red>Subtasks</font></TD>
<TD><font color=red>Name</font></TD>
<TD></TD>
<TD><font color=red>Funding</font></TD>
<TD><font color=red>Funding</font></TD>
<TD><font color=red>Amount</font></TD>
</TR>
<TR>
<TD id="subtask">00V1</TD>
<TD id="projname">V1</TD>
<TD><INPUT TYPE="hidden" NAME="in_chargeprojid" VALUE="1490"></TD>
<TD>$2,877,488.74<INPUT TYPE="hidden" NAME="in_origfunding" VALUE="2877488.74"></TD>
<TD><INPUT TYPE="text" NAME="in_newfunding" SIZE="14" MAXLENGTH="14" VALUE="2877488.74" onKeyUp="elements[3].value = makemoney(elements[2].value - elements[1].value)"></TD>
<TD><INPUT TYPE="text" NAME="in_changeamt" SIZE="14" MAXLENGTH="14" VALUE="0.00" onKeyUp="elements[2].value = makemoney((elements[3].value - 0) + (elements[1].value - 0))"></TD>
</TR>
<TR>
<TD id="subtask">00V2</TD>
<TD id="projname">V2</TD>
<TD><INPUT TYPE="hidden" NAME="in_chargeprojid" VALUE="1956"></TD>
<TD>$430.00<INPUT TYPE="hidden" NAME="in_origfunding" VALUE="430"></TD>
<TD><INPUT TYPE="text" NAME="in_newfunding" SIZE="14" MAXLENGTH="14" VALUE="430" onKeyUp="elements[7].value = makemoney(elements[6].value - elements[5].value)"></TD>
<TD><INPUT TYPE="text" NAME="in_changeamt" SIZE="14" MAXLENGTH="14" VALUE="0.00" onKeyUp="elements[6].value = makemoney((elements[7].value - 0) + (elements[5].value - 0))"></TD>
</TR>
<TR>
<TD></TD>
<TD></TD>
<TD></TD>
<TD ALIGN="right"><B><font color=black>$2,877,918.74 </font></B></TD>
<TD><INPUT TYPE="text" NAME="in_totalnewfunding" SIZE="14" MAXLENGTH="14" VALUE="$2,877,918.74" readonly></TD>
<TD></TD>
<TD></TD>
</TR>
</table>
<BR>
<div align="center">
Reason/Approval:
<BR>
<TEXTAREA NAME="in_notes" ROWS=5 COLS=60></TEXTAREA>
<BR>
</div>
<input type="hidden" name="in_projid" value="340">
<input type="hidden" name="in_acrnprojid" value="1489">
<BR>
<BR>
<td><INPUT TYPE="button" name="delbutton" VALUE="Delete" onclick="junk(this.form)"></td>
<BR>
<td><INPUT TYPE="button" name="sumbutton" VALUE="SUM" onclick="sum_new_funding()"></td>
<BR>
<BR>
<div align="center">
<INPUT TYPE="submit" VALUE="Continue">
</div>
</FORM>