Sorry, I just can't see where the QRY_COMMISSIONS_REPORT_ALL has the values shown in your Excel sheet, for Allen I can see
19.10, but not 7.64
13.19, but not 5.28
10.29, but not 4.12
279.9 but not 3.11

Help!