I am struggling with creating a summary saved search that will be used to populate a custom field. That custom field is on the parent record. In each child record, I have fields A, B and C. I need to get the weighted average of field C. The weight is based on A*C. The WAVG is calculated as SUM(((A*B)/SUM(A*B))*C). But I am getting unexpected results or null values. Is it even possible to get the weighted average based on the child record results?