Print Page | Close Window

Total Count Not Tallying to Group Sum

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4584
Printed Date: 02 May 2025 at 12:35am


Topic: Total Count Not Tallying to Group Sum
Posted By: terrikwei
Subject: Total Count Not Tallying to Group Sum
Date Posted: 20 Oct 2008 at 10:12pm
hey all,
 
Need a lil help ere..
 
i have this formula as below:
if mailto:%7b@differtimeinMIN - {@differtimeinMIN } >= 0 and mailto:%7b@differtimeinMIN - {@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: judylynn
Date Posted: 18 Nov 2008 at 7:45am
I think you need to change the ranges of numbers in your formula.
Instead of 0-15, 15-30, 30-45, etc...
try using 0-15, 16-30, 31-45, etc....
You are duplicating numbers so they are being counted twice.


Print Page | Close Window