How to use Min,Max,Abs functions

braindog_43 · February 7th, 2005, 06:04 AM

Guys,
   I have been trying to transform and XML file using XSLT 1.0 but haven't been able to as i want to get the minimum value,abs. I tried using EXSLT but cannot get it running as i keep getting one or the other stupid errors. If possible please provide me with a sample if ur using the namespace http://exslt.org/dynamic or math or func or sumthing.

I wanna loop thru Each Row which can contain more then 1 company nodes which in turn wuld be having one title node each containing 7 nodes each. I want to loop thru each row then company wise get the count of companies and then fetch the values of the 4th node(Title/*[4]) of the title node and then compare all the values and output the minimum value.

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="FinancialForm.xsl"?>
<Import xmlns:sql="urn:schemas-microsoft-com:xml-sql">

    <Form Fid="105" name="SCHEDULE OF QUOTED RATES FOR SUPPLY OF UPVC PIPES - 63 MM TO 315 MM DIA (RINGFIT) WITH ISI MARK. (A) 0.4 mpa (4 kg/cm2) (With Excise duty) ">
        <Row Id="584" Title="0.4 mpa (4kg/cm2 ) 63/4 ">
            <Company Id="47" Name="Prince Pipes & Fitting Pvt Ltd." gujBasedSSI="Yes" gujBasedSSIVal="1.1">
                <Title Name="4kg ( With ED)">
                    <C>25.77</C>
                    <C>0.38</C>
                    <C>4.27</C>
                    <C>30.42</C>
                    <C>3.04</C>
                    <C>33.46</C>
                    <C>thirty-three point four six</C>
                </Title>
            </Company>
            <Company Id="49" Name="Kriti Industries Ltd." gujBasedSSI="No" gujBasedSSIVal="1">
                <Title Name="RATE WITH EXCISE DUTY">
                    <C>24.66</C>
                    <C>0.74</C>
                    <C>4.15</C>
                    <C>29.55</C>
                    <C>2.95</C>
                    <C>32.50</C>
                    <C>thirty-two point five zero</C>
                </Title>
            </Company>
            <Company Id="55" Name="Intigrated thermoplastic Ltd." gujBasedSSI="Yes" gujBasedSSIVal="1.1">
                <Title Name="4 kgf with ED">
                    <C>25.44</C>
                    <C>1.78</C>
                    <C>4.44</C>
                    <C>31.66</C>
                    <C>1.26</C>
                    <C>32.92</C>
                    <C>thirty-two point nine two</C>
                </Title>
            </Company>
        </Row>

        <Row Id="590" Title="0.4 mpa (4kg/cm2 ) 160/4 ">
            <Company Id="47" Name="Prince Pipes & Fitting Pvt Ltd." gujBasedSSI="Yes" gujBasedSSIVal="1.1">
                <Title Name="4kg ( With ED)">
                    <C>153.78</C>
                    <C>2.31</C>
                    <C>25.47</C>
                    <C>181.56</C>
                    <C>18.16</C>
                    <C>199.72</C>
                    <C>one hundred and ninety-nine point seven two</C>
                </Title>
            </Company>
            <Company Id="48" Name="Jain Irrigation System Ltd." gujBasedSSI="Yes" gujBasedSSIVal="1.1">
                <Title Name="63mmto315mmx4kg with excise duty">
                    <C>154.96</C>
                    <C>4.06</C>
                    <C>25.29</C>
                    <C>184.31</C>
                    <C>18.43</C>
                    <C>202.74</C>
                    <C>two hundred and two point seven four</C>
                </Title>
            </Company>
            <Company Id="49" Name="Kriti Industries Ltd." gujBasedSSI="No" gujBasedSSIVal="1">
                <Title Name="RATE WITH EXCISE DUTY">
                    <C>152.88</C>
                    <C>4.59</C>
                    <C>25.70</C>
                    <C>183.17</C>
                    <C>18.32</C>
                    <C>201.49</C>
                    <C>two hundred and one point four nine</C>
                </Title>
            </Company>
            <Company Id="55" Name="Intigrated thermoplastic Ltd." gujBasedSSI="Yes" gujBasedSSIVal="1.1">
                <Title Name="4 kgf with ED">
                    <C>152.42</C>
                    <C>10.66</C>
                    <C>26.61</C>
                    <C>189.69</C>
                    <C>7.58</C>
                    <C>197.27</C>
                    <C>one hundred and ninety-seven point two seven</C>
                </Title>
            </Company>
        </Row>

    </Form>
</Import>

Tried using EXSLT but keep getting errors.

Regards,
Wilbur

Please take a look at the below XML data i'm trying to manipulate.