This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: sum() command
- From: "KUMAR NINGASHETTY" <KNINGASHETTY at deltafunding dot com>
- To: <xsl-list at lists dot mulberrytech dot com>
- Date: Tue, 20 Aug 2002 14:50:26 -0400
- Subject: Re: [xsl] sum() command
- Reply-to: xsl-list at lists dot mulberrytech dot com
There is some syntax error there ...
for valor element ..use <xsl:value-of select="sum(query/row/value[@field='valor'])"/>
For duracao element its in a different format and hence fails..Filter the data using string manipulation funcs depending
on what kinda result you need .
- kumar
>>> vitor_cavalcanti@oi.net.br 08/20/02 01:42PM >>>
Folks,
I got an error when i use the sum() command. Can you help me, guys? :)
I have following XML-structure:
<query>
<row>
<value field="data">25/07/2002</value>
<value field="hora">15:54:40</value>
<value field="grupo">2ª A 6ª</value>
<value field="tipo">Voz</value>
<value field="duracao">00:15:00</value>
<value field="valor">80.04</value>
</row>
<row>
<value field="data">25/07/2002</value>
<value field="hora">15:45:30</value>
<value field="grupo">2ª A 6ª</value>
<value field="tipo">Voz</value>
<value field="duracao">00:10:00</value>
<value field="valor">0.05</value>
</row>
<row>
....
</row>
</query>
I'm doing a <xsl:for-each select="value"> and puting all these values in a
<table> html. Now I wanna put the last line with a <td> with the total sum
of the "duracao" field and another <td> with the "valor" sum. Out of
for-each, I'm doing the following: <xsl:value-of
select="sum(/query/row[value/@field='duracao'])"/> and <xsl:value-of
select="sum(/query/row[value/@field='valor'])"/>. Both are returning NaN.
Any idea, guys?
Thanks,
Vitor
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list