xsl-list
[Top] [All Lists]

Re: [xsl] Problem accumulating values.

2011-03-03 05:44:09
The _problem_ is, that I need to calculate at the end of each week, the
total duration time of all the tasks for that week (week = duration time
of task 1 + duration time of task 2 + duration time of task 3...). I
have tried using the sum() function in different ways but did not
worked. I also tried creating a new tag inside my 'task' node, but it
just does not work, sum() keeps on appending the values instead of
summing them.

Sum is correct, for example:

sum(for $x in //task return $x/xs:dateTime(@end) - $x/xs:dateTime(@start))

returns

PT1M28S

This is how my .XSLT file looks like: http://pastebin.com/jLV2EHFa

and this is the result generated file: http://pastebin.com/dDpJVqLL

As you see, the results are appended and not summed, which is what I
need.

You are working at the <task> level, so you are outputting the sum of
just that 1 task.  You need to operate at the week level, eg change
the for-each in:

<xsl:template match="year/week">
  ....
  <xsl:for-each select="day/task">
    <xsl:call-template name="total_duration"/>
  </xsl:for-each>

to just:

<xsl:value-of select="sum(for $x in task return $x/xs:dateTime(@end) -
$x/xs:dateTime(@start))/>

(well, make it a variable and then do your formatting as you have done already)


-- 
Andrew Welch
http://andrewjwelch.com

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>