Subject: RE: [xsl] Summation and NaN From: "sumev" <skohli@xxxxxxxxxxxxxxx> Date: Mon, 6 Aug 2001 18:40:17 -0400 |
How about this <xsl:value-of select="format-number(sum(Borrower[Rank=1]/AssetSet/Asset/Amount[string(numb er(.))!='NaN']),'$.00')"/> -----Original Message----- From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of sumev Sent: Monday, August 06, 2001 6:22 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: RE: [xsl] Summation and NaN Hi Katie, Try to filter before you add [string(number(.))!='NaN'] use it with sum() C'ya sumev -----Original Message----- From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Katie McNally Sent: Monday, August 06, 2001 6:02 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: [xsl] 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. 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 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, sumev | Thread | Re: [xsl] Summation and NaN, Wendell Piez |
Re: [xsl] Summation and NaN, Wendell Piez | Date | [xsl] not() function not working, Kartheek Hirode |
Month |