StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7047871
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-08-13T01:07:37.683
FavoriteCount
0
LastActivityDate
2011-08-13T01:20:29.250
LastEditDate
2011-08-13T01:20:29.250
LastEditorUserId
756056
OwnerUserId
756056
ParentId
7043931
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Remove the dot and you will always see 3000 because all @costs (independent from starting point) will be summed. <pre class="lang-xml prettyprint-override"><code><xsl:value-of select="number(sum(//@cost))"/>  </code></pre> Output will look like this: <code>30003000</code> But I assume that something is wrong with your approach. When you call a template recursive then the output will also will be printed as much as the template calls itself in your case. You need to print out the result at the end of your recursion Given this input: <pre><code><root> <mileage value="15000"> <operation title="Replacing the engine oil" cost="500" /> <sparepart title="Oil filter" cost="250" /> <sparepart title="Motor oil" cost="1050" /> </mileage> <mileage value="30000"> <repeating mileage="15000" /> <operation title="Replacement of spark" cost="1200" /> </mileage> </root> </code></pre> and using this xslt: <pre><code><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output omit-xml-declaration="yes" indent="yes"/> <xsl:strip-space elements="*"/> <xsl:template match="/"> <xsl:apply-templates select="root"/> </xsl:template> <xsl:template match="root"> <xsl:apply-templates select="mileage[@value=30000]"/> </xsl:template> <xsl:template match="mileage[@value]"> <xsl:param name="sum" select="number(0)" /> <xsl:variable name="milinkage"><xsl:value-of select="number(repeating/@mileage)" /></xsl:variable> <xsl:variable name="newsum"> <xsl:value-of select="number(sum(.//@cost)) + $sum"/> </xsl:variable> <xsl:apply-templates select="parent::*/mileage[@value=$milinkage]"><xsl:with-param name="sum" select="number($newsum)" /></xsl:apply-templates> <xsl:if test="not(parent::*/mileage[@value=$milinkage])"> <xsl:value-of select="$newsum"/> </xsl:if> </xsl:template> </xsl:stylesheet> </code></pre> gives the correct result: <code>3000</code>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POXSLT recursive sum troubles
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UStherealmarv
UserOwnerUserId
1. UStherealmarv
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.