Running totals incorrect
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 ?
Hi Abhilash, I recreated the report and for some reason all is fine now very strange but I didn't have the time to get to the bottom of it - thanks for your help