>> I'm trying to get a list of ID's that have a total sum of their amount column = to zero... But I'm getting a lot of negative numbers, but no positives. So, for example, I might get an ID that has two rows in total which if you add up their amounts it equals -3.50. Why would that happen? I need to see those ID's whose amount column equals exactly 0. <<
No data. No DDL. No meaningful data element names. This is generally considered pretty rude for the past 30 something years of SQL forums. Are you familiar with the signum function? It returns +1 for positive numbers, 0 for zero, and -1 for negative numbers. Most programming languages compile this function to one or two assembly language instructions, so it's pretty fast.
GROUP BY generic_id
HAVING SIGN (SUM (vague_amount)) = 0;
Please post DDL and follow ANSI/ISO standards when asking for help.