Print Page | Close Window

Conditional Count Formula

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=4107
Printed Date: 29 Apr 2024 at 4:05pm


Topic: Conditional Count Formula
Posted By: Kathleen
Subject: Conditional Count Formula
Date Posted: 28 Aug 2008 at 8:56am
I am trying to create a formula that will count how many times a particular box is checked in different fields. 
 
Meaning - If subname = "Continuous Service" and "Over 10 years" = Yes, then count
 
 
Can someone please help me set up a conditional count formula for something like this?  I'm trying like this but I'm getting several errors.

Count If({EvalDetail.SubName}="Continuous Service")and({@String to Number})=1)

 


Replies:
Posted By: neinta
Date Posted: 28 Aug 2008 at 3:13pm
If ({EvalDetail.SubName}="Continuous Service" and {@String to Number} =1) then 1 else 0.

Then create a sum on the formula to get the total count.

Posted By: sree123
Date Posted: 28 Aug 2008 at 7:58pm
Can I use Decode() as we use in oracle sql plus in crystal reports?
 
Thanks


Print Page | Close Window