Aggregation function on custom field error

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 *