Hi @NicolasATC,
My invoice data is the exact same as yours, and the only thing that was different about my query is “(invoice_total - payment_total) AS what_we_expect” without the SUM function. I get the same results with or without it.
Is there anything else you suggest? If not, I guess I’ll continue this course as is, but it is gonna be a little frustrating getting different results.