Discrepancy in values in rollup field

545 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everyone–

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

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
Screen Shot 2022-07-20 at 10.08.53 AM

0 Replies 0