RE: Summation and NaN

How about this

<xsl:value-of
select="format-number(sum(Borrower[Rank=1]/AssetSet/Asset/Amount[string(numb
er(.))!='NaN']),'$.00')"/>

-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of sumev
Sent: Monday, August 06, 2001 6:22 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE:  Summation and NaN


Hi Katie,
  Try to filter before you add

[string(number(.))!='NaN']

use it with sum()

C'ya
sumev
-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Katie McNally
Sent: Monday, August 06, 2001 6:02 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject:  Summation and NaN


When I use the following:

<xsl:value-of
select="format-number(sum(Borrower[Rank=1]/AssetSet/Asset/Amount),
'$.00')"/>

the page displays "NaN" when none of the "Amount" elements in the XML have
values.  Instead of NaN, I would like the page to display nothing (a blank)
if no asset "Amount" values are returned in the XML.  How do I do this?

Thanks,
Katie


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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


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


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