Dear all,

I have a problem with XSLT calculation. Basically what I want to achieve is: to calculate the total values of ValueItem owned by at least one applicant, which means ValueItem/PercentOwned/RelatedEntityRef/@RelatedID = Party/Identifier/@UniqueID and Party/@Type = ¡®Applicant¡¯. So the total value suppose to be 98000. Please see the XML below. I can easily apply a condition within ValueItem but I really can¡¯t figure out a way to apply the condition outside ValueItem. I use XSLT 1.0. I really appreciate if anyone here can help. Thank you very much in advance.


<Application>
        <PartySegment>
            <Party Type="Applicant">
                <Identifier UniqueID="A1"/>
            </Party>
            <Party Type="Guarantor">
                <Identifier UniqueID="A2"/>
            </Party>
        </PartySegment>
        <FinancialSegment>
            <ValueItem Value="430000">
                <Identifier UniqueID="RE1"/>
                <PercentOwned>
                    <RelatedEntityRef RelatedID="A1"/>
                </PercentOwned>
                <PercentOwned>
                    <RelatedEntityRef RelatedID="A2"/>
                </PercentOwned>
            </ValueItem>
            <ValueItem Value="40000">
                <Identifier UniqueID="NR1"/>
                <PercentOwned>
                    <RelatedEntityRef RelatedID="A2"/>
                </PercentOwned>
            </ValueItem>
            <ValueItem Value="55000">
                <Identifier UniqueID="NR2"/>
                <PercentOwned>
                    <RelatedEntityRef RelatedID="A1"/>
                </PercentOwned>
            </ValueItem>
        </FinancialSegment>
    </Application>

Something like

<xsl:key name="applicant" match="Party[@Type='Applicant']"
  use="Identifier/@UniqueID"/>

then

sum(//ValueItem[key('applicant', PercentOwned/RelatedEntityRef/@RelatedID)])

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thank you very much Michael! Your code works. I really appreciate your help.

All the best,

Ken