summation of a attribute in multiple similar tags

Divya · June 16th, 2010, 06:11 AM

Hi,

Input xml:
<LPS Request>
<summary>
<Date></Date>
<amount>500</amount>
</summary>
<summary>
<Date></Date>
<amount>1500</amount>
</summary>
<summary>
<Date></Date>
<amount>2500</amount>
</summary>
<summary>
<Date></Date>
<amount>3500</amount>
</summary>
</LPS Request>

Output xml should have an attribute input amount with summation of all the amount attribute from multiple summary tags

output xml:

<LPS Request>
<InputAmount>8000</InputAmount> [500+1500+2500+3500]
</LPS Request>

Could any one please help me in this .

samjudson · June 16th, 2010, 06:14 AM

Firstly - you mention 'attribute' in your subject line. There are no attributes in your XML, only elements.

The Xpath sum() method will do what you want. It will be different depending on the context of where you place it. <xsl:value-of select="sum(Date/amount)"/> for example.

Divya · June 16th, 2010, 06:33 AM

Hi sam,

i wrote xslt like

<LPS Response>
<InputAmount>
<xsl:for-each select="LPS Request/summary">
<xsl:value-of select="sum(amount)"/>
<InputAmount>
</LPS Response>

i got the output as

<LPS Response>
<InputAmount>500150025003500</InputAmount>
</LPS Response>

samjudson · June 16th, 2010, 06:42 AM

That's strange, because neither your input file, nor your XSLT file are even valid XML, so I don't know how you manage to output anything.

mhkay · June 16th, 2010, 06:52 AM

You're saying "for each summary, give me the sum of the amounts in that summary", and that's exactly what you are getting. But you want a single sum, not one for each summary. That's sum(summary/amount), executed with LPSRequest as the context item.

If you're going to post XML/XSLT that is abstracted from the real XML/XSLT, please test it before you post it. When people make transcription errors in their posts, it's hard to tell whether that's the real problem or just a distraction caused by careless posting.

mrame · June 17th, 2010, 01:53 AM

I corrected your input xml as below

Code:

<LPS_Request>
<summary>
<Date></Date>
<amount>500</amount>
</summary>
<summary>
<Date></Date>
<amount>1500</amount>
</summary>
<summary>
<Date></Date>
<amount>2500</amount>
</summary>
<summary>
<Date></Date>
<amount>3500</amount>
</summary>
</LPS_Request>

and used the below code

Code:

<xsl:template match="LPS_Request">
<LPS_Response>
<InputAmount>
<xsl:value-of select="sum(summary/amount)"/>
</InputAmount>
</LPS_Response>
</xsl:template>

If this is not what you need, then post an error-free relevant input xml.