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: "Michael Kay" <mhkay at iclway dot co dot uk>
- Date: Tue, 7 Aug 2001 10:25:01 +0100
- Reply-To: xsl-list at lists dot mulberrytech dot com
> 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.
Actually it will display "NaN" when any one of the "Amount" elements has no
value.
Instead of NaN, I would like the page to display nothing (a blank)
Assign the result of sum() to a variable, then use <xsl:choose> to test
whether this variable is NaN. You can test for NaN by
<xsl:when test="string($total)='NaN'">
or (less readably) by
<xsl:when test="$total!=$total">
since NaN is the only value that isn't equal to itself.
Mike Kay
Software AG
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list