Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: IncorrectTotal Amount Post Reply Post New Topic
Author Message
CoachGBT
Newbie
Newbie


Joined: 08 Apr 2011
Online Status: Offline
Posts: 29
Quote CoachGBT Replybullet Topic: IncorrectTotal Amount
    Posted: 07 Oct 2011 at 5:25am
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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2011 at 6:31am
Sounds like you are placing your fields on a header or doing conditional suppressions. Neither of these exclude rows from calculations. You need to explicitly exclude rows from calculations using variable formulas or running totals.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.