Formula Counting =False Values
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=22195
Printed Date: 29 Apr 2024 at 5:34am
Topic: Formula Counting =False Values
Posted By: Chris32
Subject: Formula Counting =False Values
Date Posted: 17 Jan 2017 at 10:51pm
Hi All,
I have a report that looks specifically for incidents which are currently out of SLA. The report then tally's these up and displays this in a crosstab.
Within the same report, I am also trying to query in a separate cross tab incidents which have not been updated within 14 days or longer. I created a separate formula to pull through these incidents. However once I put this in the cross tab, an additional field appears '0.00'. The cross tab is counting incidents which HAVE been updated as well as correctly identifying the incidents that don't. Is there a way I can supress the 0.00 field or something I can add into the formula to stop it being counted in the first place?
Formula:
if {inc_data.last_action_date} >= CurrentDate - 14 then {incident.incident_ref}
Any help would be greatly appreciated!
Thanks,
Chris
|
Replies:
Posted By: hilfy
Date Posted: 18 Jan 2017 at 4:16am
In the Cross-tab expert, have you tried turning on the options to suppress empty rows and suppress empty columns?
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: Chris32
Date Posted: 18 Jan 2017 at 6:04am
Thanks for the reply, I have tried this, however the problem is, it isn't showing as an empty row. If the incidents don't match the criteria and are false, the cross tab will assign the false records as 0.00 and perform a count on how many have equalled as false. It's trying to supress the false values within the cross tab if possible.
Thanks,
Chris
|
Posted By: hilfy
Date Posted: 18 Jan 2017 at 8:39am
There are a couple of options. The easiest method would be to put this cross-tab in a subreport and only pull the data that meed the criteria. Or, you can use some more advanced cross-tab formatting using functions that access values in the current columns and rows of the cross-tab. For this you have to use the "Grid Value" functions that are only available when working directly with the cross-tab, such as in the suppression formula for the individual fields in the cross-tab.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|