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: 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.

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


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