XSL calculation

[Sebastian Gunreben]

Hi,

I spent quite some weeks seaching google groups for a solution,
but unfortunatly I didn't find anything matching my problem.
Perhaps some of you has an idea ...

My XML file looks as follows:
<Table>
<Row AttA="3" AttB="-2" AttC="2" />
<Row AttA="2" AttB="2" AttC="2" />
<Row AttA="-1" AttB="-2" AttC="6" AttC="3" />
...
</Table>

Each row has an arbitrary number of attributes. On this attributes a
function F(AttA, ..., AttC) calculates a value. The values should be
accumulated in the output. E.g. the function F is defined as:
if( AttA == 3 )
value = AttB * AttC;
else
value = AttB + AttC;

The output should look like:
<table>
<tr><td>-4</td></tr>
<tr><td>0</td></tr> <!-- -4 + 4 -->
<tr><td>4</td></tr><!-- -4 + 4 + 4 -->
</table>

To summarize my problem:
I can calculate each row by itself, dependent of the function F.
But I have some difficulties accumulating the results. Does the
solution depend
on the function F? Have you got any ideas?

Best regards

sebastian gunreben
se**@autip.de

[Joris Gillis]

> My XML file looks as follows:

<Table>
<Row AttA="3" AttB="-2" AttC="2" />
<Row AttA="2" AttB="2" AttC="2" />
<Row AttA="-1" AttB="-2" AttC="6" AttC="3" />
...
</Table>

Each row has an arbitrary number of attributes. On this attributes a
function F(AttA, ..., AttC) calculates a value. The values should be
accumulated in the output. E.g. the function F is defined as:
if( AttA == 3 )
value = AttB * AttC;
else
value = AttB + AttC;

The output should look like:
<table>
<tr><td>-4</td></tr>
<tr><td>0</td></tr> <!-- -4 + 4 -->
<tr><td>4</td></tr><!-- -4 + 4 + 4 -->
</table>
Hi,

You could use something like this:

<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="Row[1]">
<table>
<xsl:call-template name="F"/>
</table>
</xsl:template>

<xsl:template name="F">
<xsl:param name="Subtotal" select="0"/>

<xsl:variable name="fv">
<xsl:choose>
<xsl:when test="@AttA = 3">
<xsl:value-of select="@AttB * @AttC"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="@AttB + @AttC"/>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>

<tr><td><xsl:value-of select="$fv + $Subtotal"/></td></tr>

<xsl:for-each select="following-sibling::*[position()=1]">
<xsl:call-template name="F">
<xsl:with-param name="Subtotal" select="$Subtotal + $fv"/>
</xsl:call-template>
</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

Does the solution depend on the function F?

Not in my sample xslt: you can adapt the function F without problem by modifying the code inside the 'xsl:variable' tag

regards,
--
Joris Gillis (http://www.ticalc.org/cgi-bin/acct-v...i?userid=38041)
Ceterum censeo XML omnibus esse utendum

[Sebastian Gunreben]

"Joris Gillis" <ro**@pandora.be> wrote in message news:<op**************@news.pandora.be>...

[ A very good solution ]

Thank you very much, your solution solved my problem.

Regards,
sebastian

[Jeff Kish]

On 3 Nov 2004 12:30:12 -0800, se*@gunis.de (Sebastian Gunreben) wrote:

Hi,

I spent quite some weeks seaching google groups for a solution,
but unfortunatly I didn't find anything matching my problem.
Perhaps some of you has an idea ...

My XML file looks as follows:
<Table>
<Row AttA="3" AttB="-2" AttC="2" />
<Row AttA="2" AttB="2" AttC="2" />
<Row AttA="-1" AttB="-2" AttC="6" AttC="3" />
...
</Table>

Each row has an arbitrary number of attributes. On this attributes a
function F(AttA, ..., AttC) calculates a value. The values should be
accumulated in the output. E.g. the function F is defined as:
if( AttA == 3 )
value = AttB * AttC;
else
value = AttB + AttC;

The output should look like:
<table>
<tr><td>-4</td></tr>
<tr><td>0</td></tr> <!-- -4 + 4 -->
<tr><td>4</td></tr><!-- -4 + 4 + 4 -->
</table>

To summarize my problem:
I can calculate each row by itself, dependent of the function F.
But I have some difficulties accumulating the results. Does the
solution depend
on the function F? Have you got any ideas?

Best regards

sebastian gunreben
se**@autip.de

Hi.

What situation are you in as far as environment and technology.. what are your
restrictions? Can you use a command line solution, a java class solution or
what?
Jeff Kish