XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Sum and Count together
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Dogmar SSubject: Sum and Count together
Author: Dogmar S
Date: 20 Jun 2007 09:42 PM
Hello,

I am attempting to calculate the sum of the return of a count procedure and I seem not to be able to solve this. The following is what I have:

<xsl:value-of select="format-number(sum(value-of select="count(people)")"/>

The goal is the following:

If the count of people returns 1, 2, 3, 4 and then 5, then I would like for the sum to return 15. I would appreciate any help available. Thank you.

DS
Postnext
Elias HuterSubject: Sum and Count together
Author: Elias Huter
Date: 21 Jun 2007 03:21 AM
You dont have to sum the result as count already returns only one value. If you are in a for-each loop and therefore whant to sum it up, do it the other way:

Declare a variable outside the loop and fill it with the result of the count statement. So you will have all desired nodes counted.
Postnext
Dogmar SSubject: Sum and Count together
Author: Dogmar S
Date: 21 Jun 2007 08:28 AM
Hello Elias,

What you have said makes sense I think, but I am not sure if I understand. If I do the following:

<xsl:value-of select="count(people)"/>

then I get the number that I am looking for, but it is in a loop and so I am not summing those numbers (which is what I would really need to do). That is why I tried to sum the return of the count. Does this make sense? Anything else I can try? Thank you!
Posttop
Tony LavinioSubject: Sum and Count together
Author: Tony Lavinio
Date: 21 Jun 2007 10:53 AM
Could you provide a sample of your input so we can see
what you're working against, and also a sample of your
output, and also which version of Stylus Studio you are
using (since this is the Stylus Studio support forum).
 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.