Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
count formula help
- Thread starter ChipF
- Start date
synapsevampire
Programmer
Number of rows, or number of days?
Where does this count display, at the row level or just a total, or?
-k
Where does this count display, at the row level or just a total, or?
-k
Because you are trying to summarize a condition that involves 2 records, I think you are going to have to use a running total with variables.
One approach is to:
Group by AppID
Do the minimum of each date column for each group
Check to see if the MIN of QC is before the MIN of DP
Use that condition to increment the variable in your running total formula by 1. For the running total use the 3-Formula technique described in faq149-182.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
One approach is to:
Group by AppID
Do the minimum of each date column for each group
Check to see if the MIN of QC is before the MIN of DP
Use that condition to increment the variable in your running total formula by 1. For the running total use the 3-Formula technique described in faq149-182.
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB
- tek@kenhamady.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question