Print Page | Close Window

Group Sum not Tallying with Total Count

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4585
Printed Date: 04 May 2024 at 1:08am


Topic: Group Sum not Tallying with Total Count
Posted By: terrikwei
Subject: Group Sum not Tallying with Total Count
Date Posted: 20 Oct 2008 at 10:29pm
hey all,

Need a lil help ere..

i have this formula as below:
if {@differtimeinMIN} >= 0 and {@differtimeinMIN} <= 15 then
    1
else
    0

so replicating the above formula to specific groups like 0-15,15-30,30-45,45-60,>60

The Question is :
My Group Summary doesnt tally with my Count of records

say Total Count on Orders = 695 used basic count function
but results from groups
0-15=209,15-30=190,30-45=82,45-60=65,>60=176
Totaling to 722

Any Suggestion or explanation to how am i getting such untally value?

Help is kindly appreciated

Regards,
Terri


Replies:
Posted By: JohnT
Date Posted: 21 Oct 2008 at 6:36am

Looking at your example, I am wondering if it is because you have numbers in multiple groups.  For example - the number 15 would appear in the first group and the second group because you have <=.  Maybe you want your formula to be:

if {@differtimeinMIN} >= 0 and {@differtimeinMIN} < 15 then
    1
else
    0

 
You might try running your report for the first group only.  Check your counts and make sure they are correct.  Add the code for the second group and again, make sure your counts are correct.  Continue with all the groups.  That might make it easier to debug the problem.
 

 


Print Page | Close Window