I have a report that has 3 records. Each records has Total (QTY * Unit Price = Total) and Grand Total for all 3 records.
Rec QTY Unit Price Total
1 4 42.00 168.00
2 4 1.28 5.12
3 5 0.00 0.00
The report produces a Grand Total of 341.12, when it should produce a Grand Total of 173.12.
When I do a count of Rec or QTY, I get a count of 4 instead of 3. It seems Rec #1 is caculating behind the scene for that additional 168.00.
Any suggestions would be appreciated to resolve incorrect amount.
Thanks,
CoachGBT