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: "Tim Watts" <timw at 3d3 dot com>
- Date: Tue, 7 Aug 2001 12:37:10 +1000
- Reply-To: xsl-list at lists dot mulberrytech dot com
Hi Wendell and Katie,
I was looking through the XSLT "bible" (Mike's book :)) and noticed that by
using xsl:decimal-format that you can set a string to be the output when the
values are NaN or infinity.
In the top-level of the stylesheet you could use
<xsl:decimal-format NaN="" infinity="Out of Range" />
The pages are 187-192 of version 1 of the XSLT Programmers Reference, and an
example is given on pp192.
Cheers,
Tim Watts
-----Original Message-----
From: owner-xsl-list@lists.mulberrytech.com
[mailto:owner-xsl-list@lists.mulberrytech.com]On Behalf Of Wendell Piez
Sent: Tuesday, 7 August 2001 8:35 AM
To: xsl-list@lists.mulberrytech.com
Subject: Re: [xsl] Summation and NaN
Katie,
<xsl:variable name="sum"
select="sum(Borrower[Rank=1]/AssetSet/Asset/Amount)"/>
<xsl:choose>
<xsl:when test="$sum">
<xsl:value-of
select="format-number($sum, '$.00')"/>
</xsl:when>
<xsl:otherwise> </xsl:otherwise>
</xsl:choose>
That's a clean way to do it. It'll give the space if your sum is either 0
or NaN. If you want "$0.00" when it's 0, change the test to "$sum or
($sum=0)".
Others may come up with more magical ways.
Enjoy,
Wendell
At 06:01 PM 8/6/01, you wrote:
>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
======================================================================
Wendell Piez mailto:wapiez@mulberrytech.com
Mulberry Technologies, Inc. http://www.mulberrytech.com
17 West Jefferson Street Direct Phone: 301/315-9635
Suite 207 Phone: 301/315-9631
Rockville, MD 20850 Fax: 301/315-8285
----------------------------------------------------------------------
Mulberry Technologies: A Consultancy Specializing in SGML and XML
======================================================================
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list