Finding the total value of averaged sums in XML/XSLT?

admin

Administrator
Staff member
i am putting together some payroll information for a sports team, and i'm using xml/xsl to store/output the data.

i've managed to do some of the things i wanted, but there is something that i just can't figure out how to do.

i was wondering if someone could help me out with adding up all the values from the "CAP HIT" column. i mean, i can do it node by node, but i want something more flexible, or automatic for lack of a better word. is it even possible with XSLT? btw, the actual value is supposed to be $40,333,157.

in short... the way i calculated the CAP HIT was:
CAP HIT = (salary1 + salary2 + salary3 + ... + salary(n)) / (n)

what i want to do with that value now (but don't know how) is:
Total CAP HIT = (CAP HIT for player 1) + (CAP HIT for player 2) + (CAP HIT for player 3) + ... + (CAP HIT for player (n))


here are my xml file (<!-- m --><a class="postlink" href="http://alinmateescu.name/nhl/xml/tor.xml">http://alinmateescu.name/nhl/xml/tor.xml</a><!-- m -->) and xsl file (<!-- m --><a class="postlink" href="http://alinmateescu.name/nhl/xsl/info.xsl">http://alinmateescu.name/nhl/xsl/info.xsl</a><!-- m -->).

and here's what i have so far (<!-- m --><a class="postlink" href="http://alinmateescu.name/nhl/index.php">http://alinmateescu.name/nhl/index.php</a><!-- m -->).




any help would be much appreciated.

thanks.
 
Back
Top