Re: [xsl] Summation and NaN

[Wendell Piez <wapiez at mulberrytech dot com>]

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@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