Skip to Content
0
Former Member
Apr 11, 2016 at 07:07 AM

Running totals incorrect

26 Views

Hi all, I have two running totals in my report , one counts a field called proposed_amt and the other counts a field called approved_amt , what I've noticed is, if approved_amt is null the count of proposed_amt is incorrect i.e. it's not counted ( these fields are in separate tables ) , both of these totals are being shown in a group footer. How can one count affect another ?