XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
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
becky goodfordSubject: No Average function in Stylus ?
Author: becky goodford
Date: 10 Mar 2006 01:22 PM
Hello, I have a footer summing up two different columns "Num Surveyed", and Num Responses" which works fine, however in the last column, which contains the Average of column 1 and column 2 I do not need a total, but an average of that column "Response Rate", I get an error message in WYSIWYG that there is no average function....
sooo, is there perhaps a way I can do the math manually and divide column two by column 1..I have tried the "div" operator with no success


Unknownsat-responserate(1).xml
xml file

Unknownsat-responserate(1).xsl
xsl

Postnext
Ivan PedruzziSubject: No Average function in Stylus ?
Author: Ivan Pedruzzi
Date: 10 Mar 2006 02:04 PM
The following should work

<xsl:value-of select="format-number( sum( datasettablename/response_rate ) div count(datasettablename/response_rate), '0.0%')" />

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
becky goodfordSubject: No Average function in Stylus ?
Author: becky goodford
Date: 10 Mar 2006 02:16 PM
It worked..thank you

Postnext
becky goodfordSubject: No Average function in Stylus ?
Author: becky goodford
Date: 10 Mar 2006 04:31 PM
well, kind of worked...I guess I would only want to include the count of the rows that had an amount of greater than zero...

Posttop
becky goodfordSubject: No Average function in Stylus ?
Author: becky goodford
Date: 10 Mar 2006 04:40 PM
ok, got it, this works as well. dividing the total columns

<xsl:value-of select="format-number( sum( datasettablename/num_responses)div sum(datasettablename/num_surveyed), '0.00%')" />

 
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.