It's because loan_no and Person have different groupings. What you could do is use
sum(amount) as personTotal
where Employee = 'Non Employee'
GROUP BY Person;
This new table will then associate with the original table "ACCOUNTS" on field "Person".
Or merge in via a mapping load + applymap.