Member Avatar for dollycharm

I need some help with avg... I am attached files for xml --- I am struggling.... the question i have is :

1. What is the average speed of all the dinosaurs?
A. <xsl:value-of select="format-number((sum(dinosaurs/*/speed[@units='mph'])div count(dinosaurs/*/speed[@units='mph']))"/>ft
it does not work...

or
B. <xsl:value-of select="sum(//speed) div count(//speed)" />

or

C.9. <xsl:value-of select="format-number((sum(dinosaurs/*/speed[@units='mph'])div count(dinosaurs/*/speed[@units='mph']))"/>ft

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="dine8.xsl"?>

<dinosaurs>
  <carnivore kind="Tyrannosaurus_Rex" habitat="forest swamp jungle">
    <species>Tyrannosaurus Rex</species>
    <length units="feet">42</length>
    <height units="feet">18</height>
    <weight units="tons">5</weight>
    <speed units="mph">25</speed>
    <weapon images="PictureOfTyrannosaurusTooth">
      <part-of-body>Teeth</part-of-body>
      <description>Though the Tyrannosaurus had many different sizes of teeth, all were razor sharp and some grew to lengths of <b>9-13 inches</b>. Broken teeth were replaced frequently by newer teeth. The powerful jaw exerted in excess of 3000 pounds of pressure!        </description>
    </weapon>
    <discoverer>
      <name>Osborn</name>
      <year>1905</year>
    </discoverer>
    <location>
      <country>Canada</country>
      <region>Alberta</region>
    </location>
    <description>The Tyrannosaurus Rex was the king of the terrible lizards. Though many now believe it was a hunter and a scavenger it is no less fearsome.</description>
  </carnivore>
  <herbivore kind="Stegosaurus_Armatus" habitat="forest swamp" period="Jurassic">
    <species>Stegosaurus Armatus</species>
    <length units="feet">30</length>
    <height units="feet">14</height>
    <weight units="tons">3</weight>
    <speed/>
    <weapon images="PictureOfStegosaurusSpike PictureOfStegosaurusPlate">
      <part-of-body>Spikes</part-of-body>
      <description>The Stegosaurus had two long rows of armor along its back. At the end of its tail <b>four large spikes</b> were an excellent defense.</description>
    </weapon>
    <discoverer>
      <name>Marsh</name>
      <year>1877</year>
    </discoverer>
    <location>
      <country>United States</country>
      <region>Colorado</region>
    </location>
    <description>The Stegosaurus Armatus was, perhaps, the most <i>heavily armored</i> of all dinosaurs. It is very possible though that it was not very smart, it's brain is believed to have been the <b>size of a walnut!</b></description>
  </herbivore>
  <omnivore kind="Gallimimus_Bullatus" habitat="lakeshore prairie">
    <species>Gallimimus Bullatus</species>
    <length units="feet">18</length>
    <height units="feet">8</height>
    <weight units="pounds">1000</weight>
    <speed units="mph">45</speed>
    <weapon/>
    <discoverer>
      <name>Osm&#x00F3;lska</name>
      <name>Roniewicz</name>
      <name>Barsbold</name>
      <year>1972</year>
    </discoverer>
    <location>
      <country>Mongolia</country>
      <region>Nemegtskaya Svita</region>
    </location>
    <description>The Gallimimus Bullatus, or <i>Chicken Mimic</i> was very fast, perhaps even the fastest of all dinosaurs.</description>
  </omnivore>
</dinosaurs>
  • 2 Contributors
  • 2 Replies
  • 312 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by xml_looser
Member Avatar for xml_looser

speed in the second node is
no information about the speed
sum produces NaN ( not a number)
Helmut Hagemann

Member Avatar for xml_looser 
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
	<xsl:output method="xml" indent="yes"/>
	<xsl:template match="/">
		<Mittel>

			<xsl:call-template name="avg">
				<xsl:with-param name="kn" select="//speed"/>
				<xsl:with-param name="ho" select="count(//speed)"/>
			</xsl:call-template>
		</Mittel>
	</xsl:template>
	<xsl:template name="avg">
		<xsl:param name="kn"/>
		<xsl:param name="ho"/>
		<xsl:param name="ak" select="1"/>
		<xsl:param name="sum" select="0"/>
		<xsl:variable name="c" select="count($kn)"/>
		<xsl:choose>
			<xsl:when test="($ak &lt;= $c)and ($kn[$ak]!='0')">
				<xsl:call-template name="avg">
					<xsl:with-param name="ak" select="$ak+1"/>
					<xsl:with-param name="kn" select="$kn"/>
					<xsl:with-param name="sum" select="$sum + $kn[$ak]"/>
					<xsl:with-param name="ho" select="$ho"/>
				</xsl:call-template>
			</xsl:when>
			<xsl:when test="($ak &lt;= $c)and ($kn[$ak]='0')">

				<xsl:call-template name="avg">
					<xsl:with-param name="ak" select="$ak+1"/>
					<xsl:with-param name="kn" select="$kn"/>
					<xsl:with-param name="sum" select="$sum + $kn[$ak]"/>

					<xsl:with-param name="ho" select="$ho - 1"/>
				</xsl:call-template>
			</xsl:when>
			<xsl:otherwise>
				<xsl:value-of select="concat('entry ',$c,' ','used ',$ho,' avg ',$sum div $ho)"/>
			</xsl:otherwise>
		</xsl:choose>
	</xsl:template>
</xsl:stylesheet>

Result

<?xml version='1.0' ?>
<Mittel>entry 3 used 2 avg 35</Mittel>

Helmut Hagemann

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.