Count or Sum

[computerman29651]

I am trying to come up with some formulas to perform the following:

If I have results that are incomplete, how do I create a formula to count the incomplete resuts.

I want to be able to count the incomplete results that are >14, >7, and within 7 days.

Can anyone help with this?

 

[synapsevampire]

You need to put a little more effort into your post:

Crystal version
Database/connectivity used
Example data
Expected output

"Results that are incomplete" wins the most vague description of the week award.

-k

 

[computerman29651]

Crystal 10.0

Access Database

If let's say the Lab reults are incomplete, I would like to be able to display on the report the number of reults that are incomplete. So, if there are 20 results in the database, but only 5 are complete, then the report should show a total number of 15 as incomplete.

 

[lbass]

The question is what field would be used to determine whether a result was complete? What are the possible field results for this field?

-LB

 

[computerman29651]

The field would be the Results field (ACOM).

Possible Results

<RDL
3.0
500
.00006
Completed

 

[lbass]

How does the date field fit in? You seem to want to show a difference between two dates--some unknown beginning date and the current date for those records with no completion date?

Please spend some time explaining in more depth what you are trying to do.

-LB

 

[computerman29651]

I have an access report that does what I need for it to do.

The formulas I have in access is as following:

Incomplete

=Count([ACOD]}

>14 Days

=Count(iif(Date()-[SDAT]>14,1,Null))

>7 Days

=Count(iif(Date()-[SDAT]>7 and Date()-[SDAT]<=14,1,Null))

Recv'd within 7 Days

=Count(iif(Date()-[SDAT]<=7,1,Null))


I just need to convert these formulas to Crystal.

Does this help?

 

[lbass]

No, not really. Please show sample data that shows the date field(s) and the ACOM field.

-LB