Am I missing the obvious??

crazeydazey · August 3rd, 2006, 09:05 AM

Hi,

I almost feel silly asking this question, but I all I want to do is add 4 numbers together in XSL.

for example the XML would be something like

Code:

<root>
  <val1>1</val2>
  <val2>2</val2>
  <val3>3</val3>
  <val4>4</val4>

XSL (easy)

Code:

  <xsl:value-of select="root/val1 + root/val2 ..etc" />

but if say val2 was empty then we get NaN.

I have tried writing a template that checks each value and if its not a number then it assigns as a zero, but I went wrong somewhere and got myself stuck in some recursive loop..

Any ideas??

Many Thanks

Darren

mhkay · August 3rd, 2006, 09:18 AM

Try sum(root/*[text()]) which sums the values of those children that have content.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

crazeydazey · August 3rd, 2006, 09:34 AM

Ah, sorry I've not explained myself too good, I think it was my XML example that through it. the example i gave was a nice easy bit of xml, the actual xml is not so nice and the nodes are scattered all over the place, and could not even exsist for some cases.

so i need to check the node exsists, check the value is a number and add them all together..

Cheers

Darren

mhkay · August 3rd, 2006, 10:01 AM

In XSLT 2.0, write a function:

<xsl:function name="f:default-number" as="xs:double">
  <xsl:param name="node" as="node()?"/>
  <xsl:sequence select="if ($node and ($node castable as xs:double))
       then number($node) else 0.0e0"/>
</xsl:function>

then apply this function to every node before including it in the summation.

In 1.0, as always, it's the same principle but a lot more tedious.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

crazeydazey · August 4th, 2006, 03:17 AM

Excellent..

Cheers

Darren