Subject:sum function help Author:radz mys Date:30 Jun 2010 08:54 PM Originally Posted: 30 Jun 2010 12:27 PM
I've got something like this:
<course>
<par holeNumber="1">4</par>
<par holeNumber="2">4</par>
<par holeNumber="3">5</par>
<par holeNumber="4">3</par>
<par holeNumber="5">4</par>
<par holeNumber="6">4</par>
</course>
<golfer>
<name>Brett</name>
<round roundNumber="1">
<score holeNumber="1">4</score>
<score holeNumber="2">4</score>
<score holeNumber="3">5</score>
<score holeNumber="4">2</score>
<score holeNumber="5">4</score>
<score holeNumber="6">4</score>
</round>
<round roundNumber="2">
<score holeNumber="1">3</score>
<score holeNumber="2">4</score>
<score holeNumber="3">5</score>
<score holeNumber="4">3</score>
<score holeNumber="5">4</score>
<score holeNumber="6">4</score>
</round>
<round roundNumber="3">
<score holeNumber="1">3</score>
<score holeNumber="2">4</score>
<score holeNumber="3">6</score>
<score holeNumber="4">3</score>
<score holeNumber="5">4</score>
<score holeNumber="6">4</score>
</round>
</golfer>
Need to put the foll. in a p tag:
<p>Score:r1-r2-r3: allRounds(parScore)</p>
where r1,r2,and r3 are the sums of the score elements within the 1st,2nd and 3rd round; allRounds is the sum of the score elements from all the rounds, and parScore is the sum of all the score elements minus 4 times the sum of all the par elements in the source document.
I know sum(round/score) gives me the value for allRounds. I need help figuring out how to find values of r1/r2/r3. Please help.