When I try to create a data processor with aggregation function (SUM) on a custom field produces "**DB Error: no such field**". When I check the log, the error is related to the custom field being missing because the name of the field used in the query is not correct. Here is the query that generates the error where the field "**contribution_Gifts_US_Amount**" is not in my database. The actual field name in the custom field value table is **us_amount_101** > * SELECT > COUNT( * ) AS count > FROM > ( > SELECT DISTINCT > SUM( `contribution_Gifts`.`contribution_Gifts_US_Amount` ) AS `sum`, > `address`.`country_id` AS `country` > FROM > ( > SELECT > `_contribution`.`id` AS `id`, > `_contribution`.`contact_id` AS `contact_id`, > `_contribution`.`financial_type_id` AS `financial_type_id`, > `_contribution`.`contribution_page_id` AS `contribution_page_id`, > `_contribution`.`payment_instrument_id` AS `payment_instrument_id`, > `_contribution`.`receive_date` AS `receive_date`, > `_contribution`.`non_deductible_amount` AS `non_deductible_amount`, > `_contribution`.`total_amount` AS `total_amount`, > `_contribution`.`fee_amount` AS `fee_amount`, > `_contribution`.`net_amount` AS `net_amount`, > `_contribution`.`trxn_id` AS `trxn_id`, > `_contribution`.`invoice_id` AS `invoice_id`, > `_contribution`.`invoice_number` AS `invoice_number`, > `_contribution`.`currency` AS `currency`, > `_contribution`.`cancel_date` AS `cancel_date`, > `_contribution`.`cancel_reason` AS `cancel_reason`, > `_contribution`.`receipt_date` AS `receipt_date`, > `_contribution`.`thankyou_date` AS `thankyou_date`, > `_contribution`.`source` AS `source`, > `_contribution`.`amount_level` AS `amount_level`, > `_contribution`.`contribution_recur_id` AS `contribution_recur_id`, > `_contribution`.`is_test` AS `is_test`, > `_contribution`.`is_pay_later` AS `is_pay_later`, > `_contribution`.`contribution_status_id` AS `contribution_status_id`, > `_contribution`.`address_id` AS `address_id`, > `_contribution`.`check_number` AS `check_number`, > `_contribution`.`campaign_id` AS `campaign_id`, > `_contribution`.`creditnote_id` AS `creditnote_id`, > `_contribution`.`tax_amount` AS `tax_amount`, > `_contribution`.`revenue_recognition_date` AS `revenue_recognition_date`, > `_contribution`.`is_template` AS `is_template`, > `_contribution_soft`.`contribution_id` AS `contribution_soft_contribution_id`, > `_contribution_soft`.`contact_id` AS `contribution_soft_contact_id`, > `_contribution_soft`.`amount` AS `contribution_soft_amount`, > `_contribution_soft`.`currency` AS `contribution_soft_currency`, > `_contribution_soft`.`pcp_id` AS `contribution_soft_pcp_id`, > `_contribution_soft`.`pcp_display_in_roll` AS `contribution_soft_pcp_display_in_roll`, > `_contribution_soft`.`pcp_roll_nickname` AS `contribution_soft_pcp_roll_nickname`, > `_contribution_soft`.`pcp_personal_note` AS `contribution_soft_pcp_personal_note`, > `_contribution_soft`.`soft_credit_type_id` AS `contribution_soft_soft_credit_type_id` > FROM > `civicrm_contribution` `_contribution` > LEFT JOIN `civicrm_contribution_soft` `_contribution_soft` ON `_contribution`.`id` = `_contribution_soft`.`contribution_id` > ) `contribution` > LEFT JOIN `civicrm_value_gifts_13` `contribution_Gifts` ON `contribution`.`id` = `contribution_Gifts`.`entity_id` > INNER JOIN `civicrm_address` `address` ON `address`.`contact_id` = `contribution`.`contact_id` > WHERE > 1 > AND `contribution`.`is_test` = 0 > AND `contribution`.`receive_date` BETWEEN 20201001000000 > AND 20201028235959 > AND `address`.`is_primary` = 1 > ORDER BY > `country` ASC > ) `count_combined_sql_data_flow` *