Not blank

[AlreadyLost]

I want to do a count on facility_id with the following condition:
(If Comply date is not blank then facility id)

This is my formula:
If not isnull({TB_INSPECTION.COMPLIED_DATE})
then {TB_PROGRAM.FACILITY_ID}

When I pull this field in the report, I get a blank result. Why is that? {TB_INSPECTION.COMPLIED_DATE} does contain blank and data..

What can I do so that it would count only those with date populated?

 

[rosemaryl]

Dear Already Lost,

Null and blank are two different animals ....

So you want to count the facilities that have a Complied Date.

I think the following would work:

//formula start
If isnull({TB_INSPECTION.COMPLIED_DATE})
or
{TB_INSPECTION.COMPLIED_DATE} = ''
then 0
else 1

//formula end

Place that formula in the detail section and right click the field/Insert/Summary/Sum Choose where to place the summary.

Hope that helps,

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762