I have an xml document where I'm trying to sum up a node set but the node set contains a currency code. When I use sum(substring-before()) to retrieve numeric portion of the element/node and try to sum it up, I get the not a node-set error which I understand why. I haven't been alble to figure out how to sum() the values after removing the currency code.

This is my input XML.

<Release>
<ReleaseRefnum>
<ReleaseRefnumQualifierGid>
<Gid>
<DomainName>TEKNION</DomainName>
<Xid>NET PRICE</Xid>
</Gid>
</ReleaseRefnumQualifierGid>
<ReleaseRefnumValue>15889.61 CAD</ReleaseRefnumValue>
</ReleaseRefnum>
</Release>

<Release>
<ReleaseRefnum>
<ReleaseRefnumQualifierGid>
<Gid>
<DomainName>TEKNION</DomainName>
<Xid>NET PRICE</Xid>
</Gid>
</ReleaseRefnumQualifierGid>
<ReleaseRefnumValue>30412.71 CAD</ReleaseRefnumValue>
</ReleaseRefnum>
</Release>

This is the invalid xpath statement.

<DeclaredValue>
<xsl:value-of select="sum(substring-before(Release/ReleaseRefnum[ReleaseRefnumQualifierGid/Gid/Xid='NET PRICE']/ReleaseRefnumValue,' '))"/>
</DeclaredValue>

I'm using xslt 1.0 and the below values are included in my stylesheet.

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="translator" version="1.0" xmlns:otm="http://xmlns.oracle.com/apps/otm" xmlns:translator="http://www.jclark.com/xt/java/glog.webserver.i18n.Translator">

Does anyone know how I can resolve and total up values after applying a function to remove the currency code..?

thanks...Brian

After further research on VelocityReviews I found the following solution.

I used a for-each loop to set the value of a xslt variable (ie: DeclaredValues) to a temporary tree whose elements contain the values to sum after stripping off the currency code with a substring-before function.

I initialized the temporary tree element => TempDeclaredValue = 0 so I never have an empty node.

<xsl:variable name="DeclaredValues">
<TempDeclaredValue>0</TempDeclaredValue>
<xsl:for-each select="Release/ReleaseRefnum[ReleaseRefnumQualifierGid/Gid/Xid='NET PRICE']/ReleaseRefnumValue">
<TempDeclaredValue>
<xsl:value-of select="substring-before(../ReleaseRefnumValue,' ')"/>
</TempDeclaredValue>
</xsl:for-each>
</xsl:variable>

After iterating through all of the NET PRICE reference num elements, I then just execute a sum() function on the variable => DeclaredValues. The only caveat was that I had to include the namespace/extension library => xmlns:exslt="http://exslt.org/common" and use exslt:node-set() so I could sum the nodes correctly because I was getting the error

{"To use a result tree fragment in a path expression, first convert it to a node-set using the msxsl:node-set() function."}

<TotalDeclaredValue>
<xsl:value-of select="sum(exslt:node-set($DeclaredValues)/*)"/>
</TotalDeclaredValue>

Hope this helps others that are having a similiar issue.