Suming value

Kirika · April 14th, 2008, 11:29 AM

Hi,

I've got a problem with suming up some value from my xml.

Here it is :

Code:

<output-objects>
    <output-object name="test">
      <attribute name="Currency">
        <text>EUR</text>
      </attribute>
      <attribute name="Total">
        <number>80000.08</number>
      </attribute>
    </output-object>
    <output-object name="test">
      <attribute name="Currency">
        <text>RON</text>

      </attribute>
      <attribute name="Total">
        <number>70000.07</number>
      </attribute>
    </output-object>
    <output-object name="test">
      <attribute name="Currency">
        <text>EUR</text>
      </attribute>
      <attribute name="Total">
        <number>60000.06</number>

      </attribute>
    </output-object>
</output-objects>

I'm trying to sum up the attribute 'Total' only when the Currency attribute is set to 'EUR'. So basicly, in this example, I want to sum : 80000.08 + 60000.06 only. I didn't manage to do it with solutions I've tried.

Hope that someone can help me...

Thanks in advance !

Martin Honnen · April 14th, 2008, 11:36 AM

Here is a template:

Code:

  <xsl:template match="/">
    <xsl:value-of select="sum(output-objects/output-object[attribute[@name = 'Currency']/text = 'EUR']/attribute[@name = 'Total']/number)"/>
  </xsl:template>

--
Martin Honnen
Microsoft MVP - XML

Kirika · April 18th, 2008, 04:27 AM

Thanks a lot the answers

Martin Honnen · April 18th, 2008, 05:53 AM

Does it now work for you?
Note that my post has
[code]
<xsl:template match="/">
</code]
while your post has

Code:

<xsl:template match="output-objects">

meaning that you need to change the XPath expression:

Code:

<xsl:value-of select="sum(output-object[attribute[@name = 'Currency']/text = 'EUR']/attribute[@name = 'Total']/number)"/>

--
Martin Honnen
Microsoft MVP - XML