xsl-list
[Top] [All Lists]

Re: summing up incrementally

2003-12-18 22:26:58
On Fri, Dec 19, 2003 at 12:23:34AM +0000, David Carlisle wrote:

that would just be <xsl:value-of 
select="sum(preceding-sibling::year/month[(_at_)month='December']/@percentage-increase)"/>

Yes, that works nicely. I need to really see how sum works. The book I
mainly use (*XSLT Quickly*) gives about 1/2 a page to sum, so I didn't
know you could use it this way.

But it sounds like you want a product, not a sum????

cumulative interest isn't additive
The increase over three years is 1.03 * 1.02 * 1.08 =~ 1.135 or 13.5%
so you will need a recursive template as xpath2 doesn't have a product
built in (or you could use saxon7's implementation of xpath 2 draft,
which does)

Actually, I am not working with interest on a loan. I am working with
the gross sales of chain stores. Each month in December the statistics
give the percentage of increase from the previous year. So if in 1934
the store increased its sales 5 percent, and then in 1935 increased it 7
percent, the total increase from 1933 is 12 percent. I'm using the
percent from a periodical, but I don't think the periodical adjusted for
inflation, so I may have to do some additional math. 

But I get the idea of sum--thanks!

Paul

-- 

************************
*Paul Tremblay         *
*phthenry(_at_)earthlink(_dot_)net*
************************

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list