Re: [Qexo-general] problems aggregating with sum()

[Per Bothner]

Kevin Y. Kim (Lists) wrote:
> Interesting.  I also tried AVG() and that seem to work.  I would
> assume that AVG() and SUM() would have to do the same conversion
> at some point.

They should - but don't.  'avg' is "hand-conded" and includes
explicit calls to numberValue.  'sum' is implemented using the
general Reduce mechanism, and so doesn't.

> > As a work-around try:
> >   sum(for $none in $recs/value/text() return number($node))
>
>
> I assume that should read:
>     sum(for $node in $recs/value/text() return number($node))

Yes.
--
        --Per Bothner
address@hidden   http://per.bothner.com/