G
greatmacoy
sample report layout:
CODE | DESC | PHYSICAL CNT | RECORDED CNT | DISCREPANCY | REMARKS
123a abc1 54 120 INV CNT
123a abc1 25 120 COR CNT
_____________________________________________
79 120 -41
123b abc2 5 20 INV CNT
_____________________________________________
5 20 -15
456x xyzn 15 7 INV CNT
_____________________________________________
15 7 8
_________________________________________________________
99 147 -48
The group sum for the recorded count is not actually a group sum,
just copied the value for that field bec the value being refered to i
every entry (for each group) is one and the same and should not b
added-up. So the 120 "group sum" after the first group is no
incorrect, its really supposed to be 120 and not 240.
NOW: How can I make the overall sum for that column correct, it shoul
only sum the "GROUP SUM" of the RECORDED CNT column. The one I alread
made is a huge mistake because it sums-up the data in the detai
section not the data in the group footer section
CODE | DESC | PHYSICAL CNT | RECORDED CNT | DISCREPANCY | REMARKS
123a abc1 54 120 INV CNT
123a abc1 25 120 COR CNT
_____________________________________________
79 120 -41
123b abc2 5 20 INV CNT
_____________________________________________
5 20 -15
456x xyzn 15 7 INV CNT
_____________________________________________
15 7 8
_________________________________________________________
99 147 -48
The group sum for the recorded count is not actually a group sum,
just copied the value for that field bec the value being refered to i
every entry (for each group) is one and the same and should not b
added-up. So the 120 "group sum" after the first group is no
incorrect, its really supposed to be 120 and not 240.
NOW: How can I make the overall sum for that column correct, it shoul
only sum the "GROUP SUM" of the RECORDED CNT column. The one I alread
made is a huge mistake because it sums-up the data in the detai
section not the data in the group footer section