 			,d.parent_region_id
 			,d.campaign_id
 			,d.indicator_id
-			,SUM(d.value) as value
+			,SUM(COALESCE(d.value,0.00)) as value
 		FROM _to_agg d
 
 		WHERE NOT EXISTS (

			AND ta.indicator_id = ad.indicator_id
		);

		RETURN QUERY

		SELECT ad.region_id FROM agg_datapoint ad

			AND d.campaign_id = ta.campaign_id
			AND d.indicator_id = ta.indicator_id
		)
		AND d.parent_region_id is not null
		GROUP BY d.parent_region_id, d.campaign_id, d.indicator_id;

		CREATE UNIQUE INDEX rc_agg_ix ON _tmp_agg(region_id,campaign_id,indicator_id);

		-- OVERRIDES --
		UPDATE _tmp_agg ta
		SET   value = d.value
			, datapoint_id = d.id
		FROM datapoint d
		WHERE ta.region_id = d.region_id
