This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Summation and NaN
- To: xsl-list at lists dot mulberrytech dot com
- Subject: RE: [xsl] Summation and NaN
- From: "Crowers, Steve" <scrowers at liberate dot com>
- Date: Mon, 6 Aug 2001 18:20:41 -0400
- Reply-To: xsl-list at lists dot mulberrytech dot com
try
<xsl:if test="sum(Borrower[Rank=1]/AssetSet/Asset/Amount) !=
'NaN'"><xsl:value-of
select="format-number(sum(Borrower[Rank=1]/AssetSet/Asset/Amount),
'$.00')"/></xsl:if>
Steve Crowers
Software Engineer
Liberate Technologies
2 Walnut Grove,
Suite 200
Horsham, PA 19044
Phone: 215-773-9400 x 9514
Fax: 215-773-9401
scrowers@liberate.com
http://www.liberate.com
-----Original Message-----
From: Katie McNally [mailto:kmcnally9@hotmail.com]
Sent: Monday, August 06, 2001 6:02 PM
To: xsl-list@lists.mulberrytech.com
Subject: [xsl] 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