Print Page | Close Window

ow to count if data meets a criteria

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=21558
Printed Date: 04 May 2024 at 11:34pm


Topic: ow to count if data meets a criteria
Posted By: tylerp
Subject: ow to count if data meets a criteria
Date Posted: 22 Jun 2015 at 7:28am
I am trying to figure out how to set a rule to have a new column generate a count if the data in target column pulls in 2 or more results. The target column is contact date, and I need a list of people with 2 or more contact dates. Please help.


Replies:
Posted By: DBlank
Date Posted: 23 Jun 2015 at 4:48am
it depends on the specifics of the data.
It sounds like you are talkingabout a group condition.
You might be able to
group on 'person'
create a distinct count of the date field at that group level
create a running total (or shared variable formulas) using that group summary as the condition

Posted By: tylerp
Date Posted: 23 Jun 2015 at 11:26am
"create a distinct count of the date field at that group level
create a running total (or shared variable formulas) using that group summary as the condition"

How do I do these two things? I know how to group. I know how to do a running total but not the others.

Thank you very very much for your time!!!!

Posted By: DBlank
Date Posted: 24 Jun 2015 at 3:48am

group on person

insert a summary (sigma sign)
select the contactdate field
set it to a distinct count
set it at the person gfroup level
 
it will result something like
DistinctCount ({table.ContactDate}, {table.person})
 
create a running total
field to summarize= personid
type = distinctcount
evaluate = use a formula
DistinctCount ({table.ContactDate}, {table.person})>1
reset = never
place in report footer


Print Page | Close Window