Re: [xsl] Boolean XPath Expression and sum

Subject: Re: [xsl] Boolean XPath Expression and sum
From: Francis Norton <francis@xxxxxxxxxxx>
Date: Wed, 09 May 2001 18:37:39 +0100

Michael Kay wrote:
> 
> > I need to sum up the all the values of things where their
> > value is not equal
> > to N/A, and am having a bit of trouble.
> > XML might look like
> > <abuncha>
> > <thing>1</thing>
> > <thing>2</thing>
> > <thing>3</thing>
> > <thing>5</thing>
> > <thing>N/A</thing>
> > </abuncha>
> 
> sum(//thing[.!='N/A'])
> 
Given that sum() just gives up as soon as it hits a non-number, you
might want to consider

	sum(//thing[string(number(.)) != 'NaN'])

Francis.

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread