Subject: RE: [xsl] Summation and NaN From: "Tim Watts" <timw@xxxxxxx> Date: Tue, 7 Aug 2001 12:37:10 +1000 |
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@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Wendell Piez Sent: Tuesday, 7 August 2001 8:35 AM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx 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@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 XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Summation and NaN, Wendell Piez | Thread | RE: [xsl] Summation and NaN, Michael Kay |
Re: [xsl] Reasons behind implicit r, Goetz Bock | Date | [xsl] Incremental DOM->DOM XSLT pro, Luke Matkins |
Month |