xsl-list
[Top] [All Lists]

Re: Calculate average value recursively

2006-01-22 06:51:22
Weiran Zhang wrote:
I'm trying to calculate the average for a set of rainfall values in the following node-set:

<month number="1">
    <day number="1">
        <rainfall>1.5</rainfall>
    </day>
    <day number="2">
        <rainfall>0.5</rainfall>
    </day>
    <day number="3">
        <rainfall>TR</rainfall>
    </day>
    ...
</month>

Usually, I'd use "sum(month/day/rainfall) div count(month/day)" to get the average rainfall, however, as null values are represented as "TR", that expression returns a NaN error.

Just avoid selecting "TR" values, for example:
 sum(month/day/rainfall[.!='TR']) div count(month/day[rainfall!='TR'])
or
 sum(month/day/rainfall[.!='TR']) div count(month/day)
depending on what your definition of "average" is.

J.Pietschmann

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



<Prev in Thread] Current Thread [Next in Thread>