Summation of element vaoues in a loop

saralay · April 15th, 2013, 12:55 AM

Hi all,

My requirement is to sum the monetary amount values for all the same ReleaseGid/Gid/Xid values.

Ex:
input payload:
<AllocationBase>
<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302179</Xid>
</Gid></ReleaseGid>
<Cost>
<FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>250</MonetaryAmount>
</FinancialAmount></Cost>
</AllocReleaseDetail>

<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302179</Xid>
</Gid></ReleaseGid>
<Cost><FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>350</MonetaryAmount>
</FinancialAmount></Cost>
</AllocReleaseDetail>

<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302180</Xid>
</Gid></ReleaseGid>
<Cost><FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>550</MonetaryAmount>
</FinancialAmount></Cost>
</AllocReleaseDetail>

<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302180</Xid>
</Gid></ReleaseGid>
<Cost><FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>150</MonetaryAmount>
</FinancialAmount></Cost>
</AllocReleaseDetail>

<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302180</Xid>
</Gid></ReleaseGid>
<Cost><FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>300</MonetaryAmount>
</FinancialAmount></Cost>
</AllocReleaseDetail>
</AllocationBase>

Output payload:

<AllocationBase>
<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302179</Xid>
</Gid></ReleaseGid>
<Cost>
<FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>600</MonetaryAmount> 
</FinancialAmount></Cost>
</AllocReleaseDetail>

<AllocReleaseDetail>
<ReleaseGid><Gid>
<Xid>302180</Xid>
</Gid></ReleaseGid>
<Cost><FinancialAmount>
<GlobalCurrencyCode>USD</GlobalCurrencyCode>
<MonetaryAmount>1000</MonetaryAmount> 
</FinancialAmount></Cost>
</AllocReleaseDetail>
</AllocationBase>

Kindly help me to resolve the issue!!!

Thanks in advance!!!

Sarala

mhkay · April 15th, 2013, 05:08 AM

Code:

<xsl:for-each-group select="//Xid">
  Xid: <xsl:value-of select="current-grouping-key()" Total: <xsl:value-of select="sum(current-group())"/>
</xsl:for-each-group>