Weighted Average in Script not as Expression

[avastani]

Has anyone been successful in calculating the weighted average at script level and not run time.

[prieper]

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

[johnw]

Example:

LOAD
SomeField
,sum(Price * Weight) / sum(Weight)
RESIDENT SomeTable
GROUP BY SomeField
;