Problem with sum function

patrickero · March 11th, 2010, 11:41 AM

I've got xml:

<root>
<profile>
<name>xyz<name>
<salary1>4<salary1>
<salary2>2<salary2>
</profile>
<profile>
<name>mno<name
<salary1>8<salary1>
<salary2>6<salary2>
</profile>
</root>

I wrote such a code of xsl:

<xsl:value-of select="sum((/root/profile/salary1/text()*100) div (/root/profile/salary1/text() + (/root/profile/salary2/text()*100)))"/>

but the sum function doesn't work in this case, what should I correct to calculate value:

(salary1*100)/(salary1+salary2) of all profiles? In this example:

4*100/(4+2) + 8*100/(8+6)

Thanks for any advice.

Martin Honnen · March 11th, 2010, 12:24 PM

Do you use XSLT 2.0 or 1.0?

Martin Honnen · March 11th, 2010, 01:17 PM

With XSLT 2.0 you can use

Code:

    <xsl:value-of select="sum(
                            for $p in /root/profile
                            return ($p/salary1 * 100) div ($p/salary1 + $p/salary2)
                          )"/>

patrickero · March 15th, 2010, 05:10 AM

Martin thanks, but unfortunatelly I've got XSLT version 1.0. Is it possible to solve my problem in this case? Do I have to migrate to version 2.0?

mrame · March 15th, 2010, 07:00 AM

Try the below:

Code:

<xsl:stylesheet  version="1.0"  xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:exsl="http://exslt.org/common" extension-element-prefixes="exsl">
  
<xsl:output encoding="utf-8" indent="yes" method="html"/>
 
<xsl:template match="/">
<xsl:variable name="sum">
<xsl:for-each select="//profile">
<pro><xsl:value-of select="(salary1 * 100) div (salary1 + salary2)"/></pro>
</xsl:for-each>
</xsl:variable>
<xsl:value-of select="sum(exsl:node-set($sum)/pro)"/>
</xsl:template>

patrickero · March 15th, 2010, 09:22 AM

I've tried this , but got message:

"Cannot find the script or external object that implements prefix 'exsl'."

But if I tried this one:

<xsl:variable name="sum">
<xsl:for-each select="//profile">
<pro><xsl:value-of select="salary1"/></pro>
</xsl:for-each>
<xsl:value-of select="sum(pro)"/>
</xsl:variable>

the value of variable "sum" is: salary1salary2 (in my case 48), variable pro has a table of salary1 values.

Martin Honnen · March 15th, 2010, 09:26 AM

Which XSLT 1.0 processor do you use? Does it have an extension function to convert a result tree fragment into a node-set?

patrickero · March 15th, 2010, 09:55 AM

Hmm.. I don't know processor type. I'm using Visual Studio 2008, if it will help.

Martin Honnen · March 15th, 2010, 09:59 AM

Visual Studio uses System.Xml.Xsl.XslCompiledTransform which supports the exsl:node-set function. Did you put the

Code:

xmlns:exsl="http://exslt.org/common"

into your stylesheet?

patrickero · March 15th, 2010, 10:40 AM

OK, to sum up:

I've got an XML:

<?xml version="1.0" standalone="yes"?>
<root>
<profile>
<name>xyz</name>
<salary1>4</salary1>
<salary2>2</salary2>
</profile>
<profile>
<name>mno</name>
<salary1>8</salary1>
<salary2>6</salary2>
</profile>
</root>

and a XSLT:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:exsl="http://exslt.org/common"
extension-element-prefixes="exsl"
version="1.0">

<xsl:template match = "/" >

<html>
<head><title></title></head>

<body>
<br />
<table border="0">
<tr>

<td class="headerClass">name</td>
<td class="headerClass">salary1</td>
<td class="headerClass">salary2</td>

</tr>
<xsl:for-each select="//root/profile">
<tr>

<td><center><xsl:value-of select="name"/></center></td>
<td><center><xsl:value-of select="salary1"/></center></td>
<td><center><xsl:value-of select="salary2"/></center></td>

</tr>
</xsl:for-each>

<tr>

<td>Sum</td>
<td><center><xsl:value-of select="sum(/root/profile/salary1)"/></center></td>
<td><center><xsl:value-of select="sum(/root/profile/salary2)"/></center></td>

</tr>

<xsl:variable name="cal">
<xsl:for-each select="/root/profile">
<xsl:value-of select="(salary1 * 100) div (salary1 + salary2)"/>
</xsl:for-each>
</xsl:variable>

<tr>

<td>Calculations</td>
<td><center><xsl:value-of select="$cal"/></center></td>

</tr>

</table>
</body>
</html>

</xsl:template>
</xsl:stylesheet>

and now I've got a variable "cal" which consist of two numbers and looks like 66.66666666666667157.142857142857146, but I wanna to separate these numbers and add it together, then divide by the number of the numbers, in my example:

66.66666666666667157.142857142857146

divide into:

66.666666666666671 and 57.142857142857146

then (66.666666666666671 + 57.142857142857146)/2

I've got XSLT version 1.0, and using VS 2008. Could anyone help me, please?