Print Page | Close Window

Supress Blanks Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20754 Printed Date: 08 Apr 2025 at 6:09pm Topic: Supress Blanks Posted By: gstace Subject: Supress Blanks Date Posted: 21 May 2014 at 12:17am Hi I have a report field which looks at response times. We want to find the  average time from request received to reponse given. Both Request Time and Response Given time are in Date time format. I have worked out the time differences and the averages but there are occasions where a request is made but  reponse is not given for various reasons therefore there some requests times with blanks for Response Given time and it would appear that the average calculation is counting these blanks for the divide by part of the average. How can I supress these blanks so they are not counted in the average Hope that makes some vague kind of sense! Replies: Posted By: hilfy Date Posted: 29 May 2014 at 3:26am Rather than just using the "Count()" summary, I would create a formula like this: if not IsNull({Response Given}) then 1 else 0 You would then sum this field to get the number to divide by in your average. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Print Page | Close Window