This is where a sample workbook would really serve the process here.
Then I could see what calcs you are using, how you are using them (if any) and how you are doing totals.
If you can't share your workbook outright, maybe you could anonymize things. See this link: Anonymize your Tableau Package Data for Sharing
I created a parallel calc. Instead of doing:
(which gets evaluated at the individual record level, which is why you had to then do AVG of that calc in the column), I did:
which take the single number you have for Transaction Amount and for Quota on each row of the sheet, and does one calc for each row, not for all records that comprise the sums that went into those rows.
Worked perfectly, Thank you!