Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Has anyone been successful in calculating the weighted average at script level and not run time.
Can you be a bit more specific?
One idea would be to build the averages and in a second table you build the weighting criteria and then merge both tables.
Peter
Example:
LOAD
SomeField
,sum(Price * Weight) / sum(Weight)
RESIDENT SomeTable
GROUP BY SomeField
;