[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Summation and NaN
From: Wendell Piez <wapiez@xxxxxxxxxxxxxxxx>
Date: Mon, 06 Aug 2001 18:34:46 -0400
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>&#160;</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@xxxxxxxxxxxxxxxx
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



Current Thread
  • Summation and NaN
    • Katie McNally - Mon, 6 Aug 2001 18:05:57 -0400 (EDT)
      • sumev - Mon, 6 Aug 2001 18:32:06 -0400 (EDT)
        • sumev - Mon, 6 Aug 2001 18:50:05 -0400 (EDT)
      • Wendell Piez - Mon, 6 Aug 2001 18:35:14 -0400 (EDT) <=
        • Tim Watts - Mon, 6 Aug 2001 22:29:54 -0400 (EDT)
      • Michael Kay - Tue, 7 Aug 2001 05:24:39 -0400 (EDT)
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member