Skip to main content

New answers tagged

3 votes

help with creating new summary field

I think the following will provide you the average on sumfield extension (SELECT COALESCE(SUM(total_amount), 0) / NULLIF(COUNT(*), 0) FROM civicrm_contribution t1 WHERE t1.contact_id = NEW.contact_id ...
jitendra - fuzion's user avatar

Top 50 recent answers are included