The query module was not designed to be a reporting module, and, therefore, does not have all the features nor flexibility of reports.

When a query is filtered by appeal, it selects the gift based on the appeal. However, it selects the entire gift not just a portion of it, so the entire amount is displayed.

If the query output must match the report, delete the split gift and re-enter it as two separate gifts. Note that you will lose the functionality of using split gifts if done this way.

Instead, we recommend leaving it as is and using the modules as they were designed: use the Query module to select the gifts to include on the report and use the Reports module for reporting purposes.