Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Compute weighted average
Hello NG!
I have to dynamically compute a weighted average over certain datasets. Seeing how "SUM() OVER" can easily compute moving totals, I'd like to know if the is a similar solution for calculating moving weighted averages (MWA).
Can someone tell me, if there is such a function or do I have to compute MWA manually?
Thanks
Alex
Received on Fri Oct 06 2006 - 03:23:57 CDT