This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]

Re: Boolean XPath Expression and sum




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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]