Discrepancy in values in rollup field

Hello everyone–

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

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.


Screen Shot 2022-07-20 at 10.08.22 AM

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.