XSL: How to sum total?

Question

I have the following XML source structure:

<Bills>
    <bill ID ="02">
        <Product IDP="MH001" amount="10" price="20"/>
        <Product IDP="MH002" amount="20" price="20"/>
        <Product IDP="MH003" amount="30" price="20"/>
        <Product IDP="MH004" amount="50" price="20"/>
        <Product IDP="MH005" amount="60" price="20"/>
    </bill>
    <bill ID ="01">
        <Product IDP="MH101" amount="10" price="20"/>
        <Product IDP="MH102" amount="10" price="20"/>
        <Product IDP="MH103" amount="20" price="20"/>
        <Product IDP="MH104" amount="20" price="20"/>
        <Product IDP="MH105" amount="10" price="20"/>
    </bill>
</Bills>

HTMX view

How to calculate the total?
Please help. Many thanks

Please, post the XSLT that you have so far... – har07 Apr 18 '16 at 04:11 — har07, Apr 18 '16 at 04:11
need to use parse data then convert that in to int – Amitsharma Apr 18 '16 at 08:02 — Amitsharma, Apr 18 '16 at 08:02

score 0 · Answer 1 · edited May 23 '17 at 12:07

0

You might find my answer here helpful, since it is essentially the same question:

Sum of Multiplied Values

edited May 23 '17 at 12:07

Community

1
1

answered Apr 18 '16 at 08:10

Michael Kay

156,231
11
92
164

XSL: How to sum total?

1 Answers1