Hello everyone–

UPDATE: Nvm. I FOUND IT. I am an idiot. Please ignore this post.

I’ve been staring at my db for a few hours now and cannot seem to find the source of a discrepancy in values.

My DB stores cash advance transactions on one table for a set of customers (found on another table). To get the total of advances to display on the customer table, I simply do a rollup. HOWEVER… the rollup value is inconsistent with the total I’m getting in the other table. I’m stumped.

It’s maddening. Any ideas? Screenshots are attached if they can help.

*T